SQL Server:对表的权限 [英] SQL Server: Permissions on table

问题描述

SQL Server 2008:

SQL Server 2008 :

我如何找出什么样的角色对给定的表拥有什么样的权限.

How do I find out what kind of roles have what kind of permissions on a given table.

提前致谢.

推荐答案

您可以获得数据库中授予的所有权限并过滤掉您的表:

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

select permission_name, state, pr.name
from sys.database_permissions pe
join sys.database_principals pr on pe.grantee_principal_id = pr.principal_id
where pe.class = 1 
    and pe.major_id = object_id('<table_name>')
    and pe.minor_id = 0;

此外，您需要添加内置角色权限(db_owner、db_datareader、db_datawriter 等).也可以通过所有权链访问对象.

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.

您始终可以通过使用fn_my_permissions('table_name', 'OBJECT')

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

这篇关于SQL Server:对表的权限的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！