文档课题:oracle查询某用户授予出去以及被授予的对象权限.标签:NO,LEO,---,----------,授予,oracle,TABLE,权限,SELECT From: https://blog.51cto.com/u_12991611/5724019
> 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权限被查询出来.