RE: logon trigger to start tracing

> -----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?

My example was:
--- Jacques Kilchoer <Jacques.Kilchoer_at_quest.com> wrote:
> What database version? What is your setting for
> O7_DICTIONARY_ACCESSIBILITY?
> I tried the following in an 8.1.7 database with
> O7_DICTIONARY_ACCESSIBILITY = FALSE
>
> create user x identified by ... ;
> grant create session, create trigger to x ;
>
> (logging on as SYSDBA)
> grant execute on sys.dbms_support to x ;
>
> CONNECT X ...
> create trigger schema_trace
> after logon
> on schema
> begin
> sys.dbms_support.start_trace (waits => false, binds => false) ;
> end ;
> /
> DISCONNECT
>
> logon as user X:
> trace file created
>
> logon as user Y:
> no trace file created
>
> logon as user Y, say "alter sesssion set current_schema = X ;"
> no trace file created
>
Received on Wed Jul 23 2003 - 14:30:21 CDT