Re: AFTER LOGON System Trigger
- From: Mladen Gogala <gogala@xxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 12 Jul 2004 23:52:03 -0400
On 07/12/2004 11:34:28 PM, Mladen Gogala wrote:
> > CREATE OR REPLACE TRIGGER SESS_JOB_QUEUE AFTER LOGON
> > ON DATABASE
> >
> > BEGIN
> >
> > IF sys.login_user = 'DISCO_SCH' THEN
> > do something;
> > end if;
> >
> > END;
Of course, checking the login user the way you do also makes sense if
and only if you are checking for more then one user. Here is the proper syntax
if you are checking for a single user only:
1 CREATE OR REPLACE TRIGGER TEST_USR AFTER LOGON
2 ON SCOTT.SCHEMA
3 BEGIN
4 insert into logon_something
5 values(user||'''s mama wears army boots!');
6* END;
SQL> /
Trigger created.
--
Mladen Gogala
Oracle DBA
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
