Which all SQL Server ACLs I am part of?

I need to know in which all SQL A开发者_开发知识库CLs my Windows ID has been added to?

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