Using sys.objects When Scripting Permissions? You're Missing Something! This is an off-site link.  Please review our Terms of Service for additional information.

(Kendal Van Dyke) I suspect most DBAs have a script in their T-SQL toolbelt which scripts out database permissions for a specific user (or all users). I do, too, and for years I've used it and always assumed it did the job - until recently when I found that permissions on a certificate weren't in the output for a user I was looking at.

Read this article...

comments powered by Disqus