Oracle查看用户权限
作为DBA帐号登录,查看他的权限。
set linesize 200;
col privs_type format a10;
col username format a20;
col table_name format a35;
col column_name format a25;
col PRIVILEGE format a60;
with t1 as
(
select upper('edmond') username from dual
)
select '角色' privs_type,'NULL' username,'NULL' table_name,'NULL' column_name,wm_concat(GRANTED_ROLE) PRIVILEGE from dba_role_privs,t1 where GRANTEE=t1.username group by '角色','NULL','NULL','NULL'
union all
select '表权限',owner,TABLE_NAME,'NULL',wm_concat(PRIVILEGE) PRIVILEGE from dba_tab_privs,t1 where GRANTEE=t1.username group by '表权限',owner,TABLE_NAME,'NULL'
union all
select '列权限',owner,TABLE_NAME,column_name,wm_concat(PRIVILEGE) PRIVILEGE from dba_col_privs,t1 where GRANTEE=t1.username group by '列权限',owner,TABLE_NAME,column_name;
相关文章
- 如何删除oracle 的用户及其数据
- plsql 只能识别32位的oracle解决办法
- cmd 连接oracle
- 【docker】dbclient远程访问非本机数据库(mysql,oracle,postgres,sqlserver/mssql),测试远程数据库连通性
- 解释$ORACLE_HOME和$ORACLE_BASE的区别? .
- oracle查看表是否被锁
- oracle自动选择索引
- Oracle创建表空间、创建用户以及授权、查看权限
- 针对各主流数据mysql、sqlserver、oracle中文乱码问题。
- [Oracle 工程师手记] nologging 操作的优先级
- Oracle数据库创建表空间及用户
- Oracle 角色及其权限