学堂 学堂 学堂公众号手机端

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

lewis 5年前 (2020-11-16) 阅读数 6 #技术
文档课题: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权限被查询出来.

版权声明

本文仅代表作者观点,不代表博信信息网立场。

热门