grant to enable or disable SYS's Trigger
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.