用户拥有的系统权限selectprivilegefromdba_sys_privswheregrantee='&USERNAME'unionselectprivilegefromdba_sys_privswheregranteein(selectgranted_rolefromdba_role_privswheregrantee='&USERNAME');创建用户CREATEUSERsonggxIDENTIFIEDBYsonggxDEFAULTTABLESPACEusersTEMPORARYTABLESPACEtempQUOTA10MONusersPROFILEdefaultPASSWORDEXPIREACCOUNTUNLOCK;查询用户拥有的系统权限SELECT*FROMDBA_SYS_PRIVSWHEREGRANTEE='LIUCH'UNIONALLSELECT*FROMDBA_SYS_PRIVSWHEREGRANTEEIN(SELECTGRANTED_ROLEFROMDBA_ROLE_PRIVSWHEREGRANTEE='LIUCH');