oracle查询某用户授予出去以及被授予的对象权限
2025-04-14 09:24:14 阅读次数:1
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权限被查询出来.
版权声明:本文内容来自第三方投稿或授权转载,原文地址:https://blog.51cto.com/u_12991611/5724019,作者:Liujun_Deng,版权归原作者所有。本网站转在其作品的目的在于传递更多信息,不拥有版权,亦不承担相应法律责任。如因作品内容、版权等问题需要同本网站联系,请发邮件至ctyunbbs@chinatelecom.cn沟通。
上一篇:【数据结构】栈和队列
下一篇:STL详解(九)—— priority_queue的使用与模拟实现