主页 / server / 问题 / 43790
Accepted
jeffspost
Asked: 2009-07-22 13:28:45 +0800 CST

Oracle 用户赠款

  • 772

如何获取特定 Oracle 用户的所有安全权限列表？

security permissions oracle

1 个回答

  1. Best Answer

    用户的系统权限：

    SELECT PRIVILEGE
  FROM sys.dba_sys_privs
 WHERE grantee = <theUser>
UNION
SELECT PRIVILEGE 
  FROM dba_role_privs rp JOIN role_sys_privs rsp ON (rp.granted_role = rsp.role)
 WHERE rp.grantee = <theUser>
 ORDER BY 1;

    直接授予表/视图：

    SELECT owner, table_name, select_priv, insert_priv, delete_priv, update_priv, references_priv, alter_priv, index_priv 
  FROM table_privileges
 WHERE grantee = <theUser>
 ORDER BY owner, table_name;

    对表/视图的间接授权：

    SELECT DISTINCT owner, table_name, PRIVILEGE 
  FROM dba_role_privs rp JOIN role_tab_privs rtp ON (rp.granted_role = rtp.role)
 WHERE rp.grantee = <theUser>
 ORDER BY owner, table_name;
    • 4

相关问题