系统权限
SELECT *
FROM DBA_SYS_PRIVS
WHERE GRANTEE = 'CHAXUN'
UNION ALL
SELECT *
FROM DBA_SYS_PRIVS
WHERE GRANTEE IN
(SELECT GRANTED_ROLE FROM DBA_ROLE_PRIVS WHERE GRANTEE = 'CHAXUN');
对象权限
SELECT *
FROM DBA_TAB_PRIVS
WHERE GRANTEE = 'CHAXUN'
UNION ALL
SELECT *
FROM DBA_TAB_PRIVS
WHERE GRANTEE IN
(SELECT GRANTED_ROLE FROM DBA_ROLE_PRIVS WHERE GRANTEE = 'CHAXUN');
SELECT *
FROM DBA_SYS_PRIVS
WHERE GRANTEE = 'CHAXUN'
UNION ALL
SELECT *
FROM DBA_SYS_PRIVS
WHERE GRANTEE IN
(SELECT GRANTED_ROLE FROM DBA_ROLE_PRIVS WHERE GRANTEE = 'CHAXUN');
对象权限
SELECT *
FROM DBA_TAB_PRIVS
WHERE GRANTEE = 'CHAXUN'
UNION ALL
SELECT *
FROM DBA_TAB_PRIVS
WHERE GRANTEE IN
(SELECT GRANTED_ROLE FROM DBA_ROLE_PRIVS WHERE GRANTEE = 'CHAXUN');
扫一扫
1393
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
