十年网站开发经验 + 多家企业客户 + 靠谱的建站团队
量身定制 + 运营维护+专业推广+无忧售后,网站问题一站解决
用户拥有的系统权限 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');