开发者

system privilege issue

开发者 https://www.devze.com 2023-01-23 19:27 出处:网络
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

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

精彩评论

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