开发者

how to find the grant permission for objects from user schema

开发者 https://www.devze.com 2023-04-04 23:23 出处:网络
I have a situation like this. I have schema which h开发者_如何学Pythonas high level user \'db1owner\' and low level user \'db1user\'.

I have a situation like this. I have schema which h开发者_如何学Pythonas high level user 'db1owner' and low level user 'db1user'.

'db1owner' has grant some permissions to view, table, and other schema objects for 'db1user'.

Now I want to know the list of objects which all grant by 'db1owner' with permission details.

How can find it?

Any help indeed!

Thanks


Take a look at the ALL_TAB_PRIVS data dictionary table.

Something like....

SELECT *
FROM   ALL_TAB_PRIVS
WHERE  GRANTOR = 'db1owner'
AND    GRANTEE = 'db1user'

Description of ALL_TAB_PRIVS:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/statviews_2099.htm

0

精彩评论

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

关注公众号