Never mind. I see that DBMS_SESSION has AUTHID CURRENT_USER (and of course DBMS_SUPPORT does not.)
> -----Original Message-----
> From: Jacques Kilchoer
>
> > -----Original Message-----
> > From: Wolfgang Breitling [mailto:breitliw_at_centrexcc.com]
> >
> > The logon user needs to have granted "alter session"
> > privileges directly to
> > her, not just through a role.
>
> I believe you that it's needed for
> DBMS_SESSION.SET_SQL_TRACE, but then why was I able to get a
> trace file by using DBMS_SUPPORT, creating the trigger as a
> user that did not have ALTER SESSION privilege?
Received on Wed Jul 23 2003 - 21:03:51 CDT
