Woah--free code! A thousand thanks--this looks really close to what I'd
like to do. If I can wrestle some extra privs on our test db I'll report
back as to whether I was able to get this going on 8.1.6.
Thanks also to Lisa & Thomas for responding.
Cheers,
-Roy
Roy Pardee
Programmer/Analyst
SW
Title: RE: 8.1.6: possible to set role in db's logon trigger?
Roy,
this is in 9202 ... check the custom code for hash joins ... it has been working fine for us for > 2 months ...
CREATE OR REPLACE TRIGGER "SYSTEM".DBT_USERS_LOGON
AFTER LOGON ON DATABASE
--
DECLARE
To solve your first problem, correctly identifying the current session from
v$session, in your login trigger include:
client_info_str := 'SOME_LITTERAL_' || LTRIM(dbms_random.value,'.');
DBMS_APPLICATION_INFO.SET_CLIENT_INFO(client_info_str);
Then you can:
SELECT program, user
Title: RE: 8.1.6: possible to set role in db's logon trigger?
Hi Roy,
Note 122230.1 will answer your first question about session id's.
Lisa Koivu
Oracle Dogbone Administrator
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063
-Origin