1.查看所有用户：select*fromdba_users;select*fromall_users;select*fromuser_users;2.查看用户或角色系统权限(直接赋值给用户或角色的系统权限)：select*fromdba_sys_privs;select*fromuser_sys_privs;SQL>select*fromuser_sys_privs;USERNAMEPRIVILEGEADM-------------------------------------------------------------------------ZDZQUNLIMITEDTABLESPACENO3.查看角色(只能查看登陆用户拥有的角色)所包含的权限sql>select*fromrole_sys_privs;4.查看用户对象权限：select*fromdba_tab_privs;select*fromall_tab_privs;select*fromuser_tab_privs;5.查看所有角色：select*fromdba_roles6.查看用户或角色所拥有的角色：select*fromdba_role_privs;select*fromuser_role_privs;--查询拥有DBA权限的用户SQL>select*fromdba_role_privswheregranted_role='DBA';GRANTEEGRANTED_ROLEADMDEF------------------------------------------------------------------SYSDBAYESYESSYSTEMDBAYESYESZSZQDBANOYESKSWORK

7.查看哪些用户有sysdba或sysoper系统权限(查询时需要相应权限)select*fromV$PWFILE_USERS比如我要查看用户wzsb的拥有的角色：SQL>select*fromdba_sys_privswheregrantee='ZSZQ';GRANTEEPRIVILEGEADM-------------------------------------------------------------------------ZSZQUNLIMITEDTABLESPACENO查看一个用户所有的权限及角色selectprivilegefromdba_sys_privswheregrantee='ZSZQ'unionselectprivilegefromdba_sys_privswheregranteein(selectgranted_rolefromdba_role_privswheregrantee='ZSZQ');SQL>select*fromdba_sys_privswheregrantee='ZSZQ';GRANTEEPRIVILEGEADM-------------------------------------------------------------------------ZSZQUNLIMITEDTABLESPACENO8、查看RESOURCE具有那些权限SQL>SELECT*FROMDBA_SYS_PRIVSWHEREGRANTEE='RESOURCE';GRANTEEPRIVILEGEADM-------------------------------------------------------------------------RESOURCECREATETRIGGERNORESOURCECREATESEQUENCENORESOURCECREATETYPENORESOURCECREATEPROCEDURENORESOURCECREATECLUSTERNORESOURCECREATEOPERATORNORESOURCECREATEINDEXTYPENORESOURCECREATETABLENO已选择8行。SQL>select*fromrole_sys_privst1wheret1.role='RESOURCE';ROLEPRIVILEGEADM-------------------------------------------------------------------------RESOURCECREATESEQUENCENORESOURCECREATETRIGGERNORESOURCECREATECLUSTERNORESOURCECREATEPROCEDURENORESOURCECREATETYPENORESOURCECREATEOPERATORNORESOURCECREATETABLENORESOURCECREATEINDEXTYPENO已选择8行。

9.查看scott用户的默认表空间、临时表空间selectusername,default_tablespace,temporary_tablespacefromdba_userswhereusername='SCOTT';10.查看scott用户的系统权限selectusername,privilege,admin_optionfromuser_sys_privswhereusername='SCOTT';SQL>selectusername,privilege,admin_option2fromuser_sys_privs3whereusername='SCOTT';USERNAMEPRIVILEGEADM-------------------------------------------------------------------------SCOTTCREATEVIEWNOSCOTTUNLIMITEDTABLESPACENO11.查看赋予scott用户的对象权限selectgrantee,owner,table_name,t.grantor,t.privilege,t.grantable,t.hierarchyfromdba_tab_privstwheret.grantee='SCOTT';12.查看授予了scott的角色权限selectt.grantee,t.granted_role,t.admin_option,t.default_rolefromdba_role_privstwheret.grantee='SCOTT';SQL>selectt.grantee,t.granted_role,t.admin_option,t.default_role2fromdba_role_privst3wheret.grantee='SCOTT';GRANTEEGRANTED_ROLEADMDEF------------------------------------------------------------------SCOTTRESOURCENOYESSCOTTCONNECTNOYESSQL>select*fromuser_role_privst;USERNAMEGRANTED_ROLEADMDEFOS_---------------------------------------------------------------------ZSZQCONNECTNOYESNOZSZQDBANOYESNOZSZQEXP_FULL_DATABASENOYESNOZSZQIMP_FULL_DATABASENOYESNOZSZQRESOURCENOYESNO13.查看scott用户使用了哪些表空间selectt.table_name,t.tablespace_namefromdba_all_tablestwheret.owner='SCOTT';14.查看当前用户拥有的权限selectt.privilegefromsession_privst;SQL>selectt.privilegefromsession_privst;PRIVILEGE----------------------------------------CREATESESSIONUNLIMITEDTABLESPACECREATETABLECREATECLUSTERCREATEVIEWCREATESEQUENCECREATEPROCEDURECREATETRIGGERCREATETYPECREATEOPERATORCREATEINDEXTYPE已选择11行。15.查看角色(DBA)被赋予的角色权限select*fromrole_role_privstwheret.role='DBA';查看角色(DBA)被赋予的对象权限16.select*fromrole_tab_privst1wheret1.role='DBA';