Which all SQL Server ACLs I am part of?

Asked Jun 27 '11 at 16:05

Active Jun 27 '11 at 17:55

Viewed 222 times

-1

I need to know in which all SQL ACLs my Windows ID has been added to?

asked Jun 27 '11 at 16:05

Jwalant Natvarlal Soneji

173
1
3
8

SQL Server doesn't have ACLs in the file system sense. Need to explain more about what you're trying to do... – gbn Jun 27 '11 at 16:33

1 Answers1

0

Note sure what you're asking... but here are some pointers:

sys.login_token will show all the SIDs in your login token (Windows and SQL SIDs alike)
sys.fn_my_permissions will show all effective permissions you have
HAS_PERM_BY_NAME will tell if you have or not a specific permission

answered Jun 27 '11 at 17:55

Remus Rusanu

288,378
40
442
569