SQL Server: Permissions on table SQL Server: Permissions on table sql-server sql-server

SQL Server: Permissions on table


You can get all permissions granted in the database and filter out for your table:

select permission_name, state, pr.namefrom sys.database_permissions pejoin sys.database_principals pr on pe.grantee_principal_id = pr.principal_idwhere pe.class = 1     and pe.major_id = object_id('<table_name>')    and pe.minor_id = 0;

In addition you need to add the built in role permissions (db_owner, db_datareader, db_datawriter etc). Objects may also be accessed through ownership chaining.

You can always find out your own effective permission on any object by using fn_my_permissions('table_name', 'OBJECT')