这个“权限赋予”的过程只有打开审计才能发现的;一个用户拥有什么权限可以从以下语句获得:select * from dictionary
where table_name like 'DBA%PRIVS%'select * from DBA_SYS_PRIVS
where grantee='your_owner'select * from DBA_ROLE_PRIVS
where grantee='your_owner'/** 这个或许可以得到你想要得信息:-) **/
select * from DBA_TAB_PRIVS
where grantee='your_owner'
where table_name like 'DBA%PRIVS%'select * from DBA_SYS_PRIVS
where grantee='your_owner'select * from DBA_ROLE_PRIVS
where grantee='your_owner'/** 这个或许可以得到你想要得信息:-) **/
select * from DBA_TAB_PRIVS
where grantee='your_owner'
如果是oracle9i,可以用sys_connect_by_path(...,...)如:
select sys_connect_by_path(grantor,'->') grant_path
from dba_tab_privs
start with grantor is null
connect by prior grantee=grantor
where table_name='XXX';你试试,我机子是oracle817,试不起来。