select * from dba_role_privs; --->全部用户被授予的角色 select * from dba_roles; --->查看所有角色 Select * from ROLE_ROLE_PRIVS; --->查看所有角色被赋予的角色 基本权限查询: select * from session_privs; --->当前用户所拥有的全部权限 select * from user_sys_privs; --->当前用户的系统...
首先 scott需要大写 select * from dba_role_privs where grantee='SCOTT';如果查不出来 看看是否授权 比如sys用户下grant connect,rescouce to scott;
1.查看所有用户: select *from dba_users; select *from all_users; select *from user_users; 2.查看用户或角色系统权限(直接赋值给用户或角色的系统权限): select *from dba_sys_privs; select *from user_sys_privs; 3.查看角色(只能查看登陆用户拥有的角色)所包含的权限 sql>select *from role_sys_pri...
4.查看用户对象权限:select * from dba_tab_privs; select * from all_tab_privs; select * from user_tab_privs;5.查看所有角色:select * from dba_roles;6.查看用户或角色所拥有的角色:select * from dba_role_privs; select * from user_role_privs;...
select * from dba_role_privs; 授予用户和其他角色的角色 select * from dba_sys_privs; 授予用户和其他角色的系统权限 select * from dba_tab_privs; 数据库中对象的所有授权 select * from user_role_privs; 查看当前用户的角色
select * from dba_users; 3、查询当前用户信息 select * from dba_ustats; 4、 查看当前用户的角色 SQL>select * from user_role_privs; 5、 查看当前用户的系统权限和表级权限 SQL>select * from user_sys_privs; SQL>select * from user_tab_privs; ...
select * from dba_tab_privs; select * from all_tab_privs; select * from user_tab_privs; 1. 2. 3. 4.查看所有角色: select * from dba_roles; 1. 5.查看用户或角色所拥有的角色: select * from dba_role_privs; select * from user_role_privs; ...
select * from user_sys_privs; 3.查看用户对象权限: select * from dba_tab_privs; select * from all_tab_privs; select * from user_tab_privs; 4.查看所有角色: select * from dba_roles; 5.查看用户或角色所拥有的角色: select * from dba_role_privs; ...
select * from dba_tab_privs where owner='Username' and table_name='view_NAME'--查看该表或者视图授予给哪些用户 五、查看某角色下的权限 如何知道Oracle都有哪些内置的角色、内置的权限、角色下有什么权限? PS: connect 角色都有什么权限? 使用sys账号登录执行select * from role_sys_privs where role='...
角色的话需要重新登录或者显式的set role 来生效,而赋予系统权限是立即生效的。(P.S. 同样revoke权限也是立即生效) select any dictionary立即生效 同时开两个会话,查看情况。从上至下,按顺序。 sys@test10gr2> select * from dba_role_privs where grantee = 'TEST_USER'; ...