Re: Trace of ORA-01031 Insufficient Priviliges?

From: Anurag Varma <avarmadba.skipthis_at_yahoo.com>
Date: Fri, 18 Jul 2003 17:46:34 GMT
Message-ID: <_nWRa.2876$634.2558@nwrdny03.gnilink.net>

"SAP BASIS Consultant" <basis_consultant_at_hotmail.com> wrote in message news:dd2036f3.0307180909.5fb1e76b_at_posting.google.com...
> Hello,
>
> In a system in which SAP uses Oracle as a database, in SAP's transaction
> which controls the scheduling of backup scripts and other Oracle
> actvities, the error message 'ORA-01031' (insufficient priviliges)
> appears.
>
> I am not sure about the specific SQL statement/user (There
> are a few which SAP uses to access Oracle) combination for which
> the error appears, thouhg I have some ideas.
>
> I did not find an Oracle trace for this.
>
> Is there a way that I can set Oracle (Very old version 8.0.x..I know
> an upgrade is mandatory) to dump more information such as the
> SQL statement and the user which generates this error to a trace
> file?
>
>
>
> Thanks

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab ase_id=NOT&p_id=218105.1

<warnings>
Be careful in setting events. You can screw up the system if you set it wrong. Ask Oracle Support before setting events (especially when in doubt).
</warnings>

hth
Anurag Received on Fri Jul 18 2003 - 12:46:34 CDT