用户拥有的系统权限 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中重建索引
下一篇:MySQL有哪些常用操作