开发者

system privilege issue

I have the user for example HR which has been granted very powerful system privilege "GRANT ANY PRIVILEGE"...This user used this privilege and granted some privileges to other users...Now I want to revoke "GRANT ANY PRIVILEGE" from HR and also identify what privileges and to whom did HR user grant(I want to revoke from them this privileges).

I know that oracle saves just grantee and privilege not grantor for system privileges(unlik开发者_StackOverflow社区e object privileges) in the metadata...

If you have some idea please answer..

Thank you very much in previous.


ALL_COL_PRIVS view will show grantor ALL_TAB_PRIVS view will show grantor TABLE_PRIVILEGES view will show grantor

plus the USER versions of those..

edit:

to find the list of object privileges granted by HR use a query like this:

select * from all_tab_privs where grantor = 'HR';

i do not know of a way to check system level object grants

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜