Shulou(Shulou.com)06/01 Report--

System permissions 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') owned by the user Create user CREATE USER songgx IDENTIFIED BY songgx DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp QUOTA 10m ON users PROFILE default PASSWORD EXPIRE ACCOUNT UNLOCK Query the system permissions SELECT * FROM DBA_SYS_PRIVSWHERE GRANTEE = 'LIUCH'UNION ALLSELECT * FROM DBA_SYS_PRIVSWHERE GRANTEE IN (SELECT GRANTED_ROLE FROM DBA_ROLE_PRIVS WHERE GRANTEE =' LIUCH') owned by the user

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.