When a user is granted rights to something in SQL Server using the GRANT function where is it recorded?
In the "Master" database:
I think the INFORMATION_SCHEMA.TABLE_PRIVILEGES is only a list of what is allowed to be granted, and by whom.
There is a
Edit: It's none of the above. Instead it's the aptly named
Server level permissions are stored in internal tables exposed through the sys.server_premissions catalog view.
Database level permissions are stored in internal tables exposed through the sys.database_permissions catalog view.
A session can check its permissions by interrogating the built-in fn_my_permissions table function.
To verify if a sessions has a specific permission, use the HAS_PERMS_BY_NAME function.