Sample Header Ad - 728x90

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