扫二维码与项目经理沟通
我们在微信上24小时期待你的声音
解答本文疑问/技术咨询/运营咨询/技术建议/互联网交流
用户拥有的系统权限 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');
我们在微信上24小时期待你的声音
解答本文疑问/技术咨询/运营咨询/技术建议/互联网交流
微信二维码
移动版官网