Oracle9i 9.2.0.3.0, O7_DICTIONARY_ACCESSIBILITY is FALSE.
--- Jacques Kilchoer [EMAIL PROTECTED] 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
That's it! Thanks...sometimes I forget that a trigger is a stored
object, too.
Regards,
--- Wolfgang Breitling [EMAIL PROTECTED] wrote:
The logon user needs to have granted alter session privileges
directly to
her, not just through a role.
=
Paul Baumgartel
Transcentive, Inc.
Title: RE: logon trigger to start tracing
Paul,
remember it is a trigger ... so it runs under executing user's privs ...
1. everyone needs a direct grant for execute on dbms_session
2. there needs to be a public synonym for dbms_session
3. yell Bingo!
Raj
--- Jamadagni, Rajendra [EMAIL PROTECTED] wrote:
Paul,
remember it is a trigger ... so it runs under executing user's privs
...
1. everyone needs a direct grant for execute on dbms_session
Been there.
2. there needs to be a public synonym for dbms_session
Done that.
3. yell Bingo!
-Original Message-
From: Wolfgang Breitling [mailto:[EMAIL PROTECTED]
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
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:[EMAIL PROTECTED]
The logon user needs to have granted alter session
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
In an attempt to catch all SQL issued by a report, I created a logon
trigger in the report's logon schema. (As SYS, I granted the user
EXECUTE on DBMS_SESSION before creating the trigger.) As the schema
owner, I am able to execute DBMS_SESSION.SET_SQL_TRACE interactively.
On logon, trace files
The logon user needs to have granted alter session privileges directly to
her, not just through a role.
At 03:54 PM 7/22/2003 -0800, you wrote:
In an attempt to catch all SQL issued by a report, I created a logon
trigger in the report's logon schema. (As SYS, I granted the user
EXECUTE on