I created a DDL trigger to keep checking on who alter, create views/tables in a database. Almost most of the update are doing by poweruser. When I try to grant execute right to them.
SQL: GRANT EXECUTE ON [trgLogDDLEvent] to #ABC_Admin
It prompts error: GCannot find the object 'trgLogDDLEvent', because it does not exist or you do not have permission.
however, when I find the trigger by SQL. It does exist. What is the problem?
select * from sys.triggers
View Complete Post