Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 14504

Privileges granted to an account or role through the security mechanism of an operating system, database manager or other system.

1
vote
I had to write a permissions audit for some compliance report a while back and now I have integrated that report into my suite of administrative DB scripts. I put a copy of the procedure that … listed first, then any server level roles, then any database roles and explicitly granted permissions. Edited to add the actual code directly in the reply rather than rely on the pastebin link CREATE …
answered Sep 17 '14 by Alf47
2
votes
You should enable trace flag 1802 on your database servers. This will allow SQL Server to retain inheritable permissions when you detach a database so you won't experience this issue going forward …
answered Sep 25 '14 by Alf47