Database Administration (MOSC)

MOSC Banner

grant to enable or disable SYS's Trigger

edited Dec 26, 2012 4:19AM in Database Administration (MOSC) 4 commentsAnswered
Hi All,

i have create a logon trigger on a database under the ownership of SYS. pupose of this trigger is not to allow coustomise schema or application schema's from login into the the database from toad, plsql dev and other same tools.

now problum is some time i need to login from application users/application schemas  to execute some SQL scipts, and current solution for that is to just disable the tirger and after execution enable is back but i dun wan to do this with sys user, i wan to give right to enable and disable logon trigger to some one speacifice user/schema only.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center