| Avinash |
Posted: Mar 05, 2005 08:01:44 AM |
Total Post: 1
Joined: Feb, 2005
|
Hi everybody.
i am new to this group.
I want to know about Logon trigger.
in which i want to restrict the user on logon.
I written the trigger but it does'nt works.
Can anybody send me a sample script for LOGON trigger
|
|
|
 Vigyan |
| Posted: Apr 05, 2005 01:37:29 PM |  |
|
Total Post: 386
Joined: May, 2001
|
LOGON trigger specify LOGON to fire the trigger whenever a client application logs onto the database. This works only for AFTER triggers.
SAMPLE CODE: Set a role for user "VIGYAN" at logon
CREATE ROLE TEST;
GRANT TEST to VIGYAN;
CREATE OR REPLACE TRIGGER VIGYAN.SET_ROLE
AFTER LOGON ON VIGYAN.SCHEMA
BEGIN
SYS.DBMS_SESSION.SET_ROLE('TEST');
END;
/
Hope it helps.
|
|
|
|
|
| Vigyan |
| Posted: Apr 05, 2005 01:56:46 PM | |
|
Total Post: 386
Joined: May, 2001
|
I have also posted this as article. Please feel free to post your comments.
You can also add your findings in this article.
Thanks,
Vigyan
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
