How to deny viewing definition of server level trigger?
0
votes
1
answer
259
views
I have several server level triggers, that I want users to deny viewing definition of. I control server level permissions, users aren't sysadmins etc.
I've tried 2 options:
### DENY VIEW ANY DEFINITION to public
it prevents users from even seeing that those triggers exist (and who knows what else), so I don't want to go with that option
### CREATE SERVER TRIGGER ... WITH ENCRYPTION
It's an option, but it says that those triggers won't be replicated, and I need to have those triggers replicated (although I can recreate them on replicas, if necessary).
Could you advice if there any other options?
Ideally it would be nice to have something like
DENY VIEW DEFINITION ON OBJECT::trigger_name TO PUBLIC
but I can't make it work for server level trigger
Asked by Andy
(1 rep)
Apr 7, 2020, 11:06 PM
Last activity: May 24, 2025, 10:07 AM
Last activity: May 24, 2025, 10:07 AM