Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Logon Trigger for certain profiles

580482Sep 19 2011 — edited Sep 19 2011
I need to run a script when a certain groups of users logon.

I thought that if assigned said users a profile then i could create a logon trigger to check for that profile,
and if the user loging on is a member of the given profile run an extra sql command/script. otherwise do nothing.

but i cant workout how to do that. and google hasn't been much help.

does anyone have any idea how i might do this ?
or suggestions of other ways to run a script/command when someone is a certain "group" logons to a database ?

thanks,
Malcolm.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 17 2011
Added on Sep 19 2011
3 comments
350 views