什么 RDBMS 命令用于告知哪个用户对特定对象拥有哪些权限？

Question

Closed. This question needs details or clarity. It is not currently accepting answers.

---

想要改进这个问题？通过编辑这篇文章添加详细信息并澄清问题。

9 年前已关闭。

Answer 1

这取决于您使用的数据库系统。 在 Oracle 中，您可以通过以下方式了解很多信息

select * from all_tab_privs;

Answer 2

这是如何做它在sql server 2005中

select dp.NAME AS principal_name,
    dp.type_desc AS principal_type_desc,
    o.NAME AS object_name,
    p.permission_name,
    p.state_desc AS permission_state_desc
    sys.database_permissions p
    OUTER JOIN sys.all_objects o
on     p.major_id = o.OBJECT_ID
inner   JOIN sys.database_principals dp
on     p.grantee_principal_id = dp.principal_id