Oracle查看用户信息

--查看所有用户select * from dba_users;select * from all_users;select * from user_users;--2.查看用户和角色系统权限select  * from dba_sys_privs;select  * from user_sys_privs;--3.查看角色所包含的权限select* from role_sys_privs;--4.查看用户对象权限select * from dba_tab_privs;select * from all_tab_privs;select * from user_tab_privs;--5.查看所有角色select * from dba_roles;--6.查看所有用户或角色所拥有的角色select * from dba_role_privs;select * from user_role_privs;--7.查看哪些用户有sysdba或sysoper系统权限select * from V$PWFILE_USERS;--8.sqlplus中查看一个用户所拥有权限select * from dba_sys_privs where grantee='username';--9.oracle删除指定用户所有表的方法select 'Drop table'||table_name||';'from all_tables where owner = 'username';--10.删除用户drop user user_name cascade ;--11.获取当前用户下所有表select table_name from user_tables;--12.删除当前用户下所有的表select 'truncate table' || table_name from user_tables;

Oracle查看用户信息