SayYou_SayMe
asked on
how to grant user to disable/enable trigger in Oracle?
I have Oracle table tableA under schema abc, and has a trigger triggerA associated to tableA .
grant alter on tableA to userA
but userA can not : alter table tableA disable all triggers
grant alter on tableA to userA
but userA can not : alter table tableA disable all triggers
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
- you are right slightwv. the GRANT TRIGGER is not available for Oracle (mix up with another db). syntax would be GRANT ADMINISTER DATABASE TRIGGER but as slightwv have mention, this is dangerous as the user are allowed to administer the whole trigger in the database.
GRANT ADMINISTER DATABASE TRIGGER TO user;
GRANT ADMINISTER DATABASE TRIGGER TO user;
>> ADMINISTER DATABASE TRIGGER
I don't think this gives permission to enable/disable triggers. I'm pretty sure you need 'alter any trigger'.
I don't think this gives permission to enable/disable triggers. I'm pretty sure you need 'alter any trigger'.
- i agree that slightwv method on 35509678 will work best :)
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Can I ask why you selected some of the answers you did since they aren't even valid Oracle syntax or only agree with a previous post?
GRANT TRIGGER ON TABLE tblname TO user