oracle查询某用户授予出去以及被授予的对象权限

文档课题：oracle查询某用户授予出去以及被授予的对象权限.

> show user

User is "LEO"

> create table test as select * from all_objects;

Table created.

> select count(*) from test;

  COUNT(*)

----------

     54948

> grant select on test to hr;

Grant succeeded

> col privilege for a20

> col type for a10

> col grantee for a15

> select * from user_tab_privs_made

GRANTEE         TABLE_NAME GRANTOR    PRIVILEGE            GRA HIE COM TYPE       INH

--------------- ---------- ---------- -------------------- --- --- --- ---------- ---

HR              TEST       LEO        SELECT               NO  NO  NO  TABLE      NO

PUBLIC          EMP01      LEO        SELECT               NO  NO  NO  TABLE      NO

PUBLIC          LEO        LEO        INHERIT PRIVILEGES   NO  NO  NO  USER       NO

说明：用户LEO授予用户HR在TEST表上的SELECT权限被查询出来.

> show user

USER is "HR"

> select * from user_tab_privs_recd

OWNER           TABLE_NAME GRANTOR    PRIVILEGE            GRA HIE COM TYPE       INH

--------------- ---------- ---------- -------------------- --- --- --- ---------- ---

ORA1            EMPLOYEES  ORA1       SELECT               NO  NO  NO  TABLE      NO

LEO             TEST       LEO        SELECT               NO  NO  NO  TABLE      NO

说明：用户HR被用户LEO授予在TEST表上的SELECT权限被查询出来.