Tuesday, 18 March 2014

Who can create and execute the Triggers?

Only the table or view owner, members of the sysadmin fixed server role, or the dbowner or ddldmin fixed database roles have permission to create, alter, drop, enable, or disable triggers.

A trigger executes under the security context of the owner of their parent object unless modified with the EXECUTE AS clause when the trigger is created or altered. 

No comments:

Post a Comment