用户拥有的系统权限
select privilege from dba_sys_privs where grantee='&USERNAME'
union
select privilege from dba_sys_privs where grantee in (select granted_role from dba_role_privs where grantee='&USERNAME');
创建用户
CREATE USER songgx
IDENTIFIED BY songgx
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE temp
QUOTA 10M ON users
PROFILE default
PASSWORD EXPIRE
ACCOUNT UNLOCK;
查询用户拥有的系统权限
SELECT *
FROM DBA_SYS_PRIVS
WHERE GRANTEE = 'LIUCH'
UNION ALL
SELECT *
FROM DBA_SYS_PRIVS
WHERE GRANTEE IN
(SELECT GRANTED_ROLE FROM DBA_ROLE_PRIVS WHERE GRANTEE = 'LIUCH');
本文标题：oracle中用户角色的查询和授权
网站链接：
http://bjjierui.cn/article/ihpcci.html
