如何Oracle查出一个用户具有的所有系统权限和对象权限

1. 系统权限

 SELECT *

 FROM DBA_SYS_PRIVS

 WHERE GRANTEE = 'LCAM_SYS_1216'

 UNION ALL

 SELECT *

 FROM DBA_SYS_PRIVS

 WHERE GRANTEE IN

      (SELECT GRANTED_ROLE FROM DBA_ROLE_PRIVS WHERE GRANTEE = 'LCAM_SYS_1216');

系统权限

2.对象权限

 SELECT *

 FROM DBA_TAB_PRIVS

 WHERE GRANTEE = 'LCAM_SYS_1216'

 UNION ALL

 SELECT *

 FROM DBA_TAB_PRIVS

 WHERE GRANTEE IN

      (SELECT GRANTED_ROLE FROM DBA_ROLE_PRIVS WHERE GRANTEE = 'LCAM_SYS_1216');

对象权限

转摘: http://blog.sina.com.cn/s/blog_5384afff0100ti0z.html

巴特西

如何Oracle查出一个用户具有的所有系统权限和对象权限

最新文章

热门文章