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
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
Hi Mike
Siebel has released a note whereby they approve CBO for the EIM process.
Also what I have is a SM Data warehouse logon into the OLTP Siebel db. The
activities this logon does is more akin to OLAP. So what I am doing is
giving this logon a big sort area size, enabling parallel access for
Has the Right to Kill or Injure
Themselves as They See Fit!
-Original Message-
From: Igor Neyman
[mailto:[EMAIL PROTECTED]]
Sent: 02 October 2002 19:09 PM
To: Multiple recipients of list
ORACLE-L
Subject: Re: logon trigger
Altering
current_schema, you will not see anything
, Every Fool Has the Right to Kill or Injure
Themselves as They See Fit!
-Original Message-
From: George
Leonard (ZA)
[mailto:[EMAIL PROTECTED]]
Sent: 03 October 2002 09:03 AM
To: Multiple recipients of list
ORACLE-L
Subject: RE: logon trigger
Thx, I
also found this last night.
I
PROTECTED]
10/03/02 02:43 AMcc:
Please respond toSubject: RE: logon trigger
Do you happen to have that note number?
Tony Aponte
-Original Message-
Sent: Thursday, October 03, 2002 2:58 AM
To: Multiple recipients of list ORACLE-L
Hi Mike
Siebel has released a note whereby they approve CBO for the EIM process.
Also what I have is a SM Data warehouse logon
cc:
Please respond toSubject: RE: logon trigger
ORACLE-L
Hi all
Ok if I execute these commands/SQL in sqlplus it works. When I add to the
trigger for after logon it
does not work.
I get the feeling it is only valid
Alter session ... is not DML, so I think you need to use dynamic SQL:
create or replace trigger smload.logon after logon on database
begin
SET TRANSACTION USE ROLLBACK SEGMENT RBBIG01;
EXECUTE IMMEDIATE Alter session enable parallel query;
EXECUTE IMMEDIATE Alter session set SORT_AREA_SIZE =
George here is how we did ours"
create or replace trigger olap1_logon_trigger after logon on
olap1.schemabegin execute immediate 'alter session set
optimizer_mode = first_rows';end;/
Customize it to your liking.
Joe
Hi,
Use dynamic SQL (execute imediate).
Also, consider placing your code into a stored proc
called by the trigger.
--- George Leonard (ZA)
[EMAIL PROTECTED] a écrit : Hi guys
I am trying to create the following trigger.
The user in question is logging in using siebel
application and
to Kill or Injure
Themselves as They See Fit!
-Original Message-
From: JOE TESTA
[mailto:[EMAIL PROTECTED]]
Sent: 02 October 2002 16:52 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: re: logon trigger
George here is how we did
ours
create or replace trigger
e Leonard (ZA)
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, October 02, 2002 12:18
PM
Subject: RE: logon trigger
Hi
all
Ok the trigger has
been changed to this, It
compiles.
The problem now is
that all the objects that need to be access is owner by the
In looking at this and thinking about it...doesn't any DDL
statement do an implied COMMIT? If so, the first EXECUTE
IMMEDIATE will fire, commit, the SET TRANSACTION will be
released, and the user will not be assured of using that
rollback segment. Shouldn't the SET TRANSACTION be the
last
Title: RE: LOGON TRIGGER
Here what we've done to alter the optimizer goal at logon time.
CREATE OR REPLACE TRIGGER change_optimizer_on_startup
AFTER LOGON ON DATABASE
DECLARE
p_osuser_txt V$SESSION_CONNECT_INFO.OSUSER%TYPE;
BEGIN
BEGIN
SELECT OSUSER
INTO p_osuser_txt
FROM V$SESSION
21 matches
Mail list logo