1 查出用户的session:
SELECT SID, SERIAL# FROM V$SESSION WHERE USERNAME='SCOTT';
2 杀掉用户SCOTT的session:
ALTER SYSTEM KILL SESSION 'SID, SERIAL#';
3 删掉用户SCOTT及用户下的表
DROP USER SCOTT CASCADE;
4 如何查看当前登录数据库的用户:
SELECT * FROM V$SESSION WHERE TYPE='USER';
5 查看所有用户
SELECT * FROM DBA_USERS
6 有时候需要导出某用户下的所有table、view、sequence、trigger等信息,下面的SQL可以将这些信息select出来:
select * from user_tables;
select * from user_views;
select * from user_sequences;
select * from user_triggers;
7 查看当前用户的默认表空间
SQL>select username,default_tablespace from user_users;
8 查看当前用户的角色
SQL>select * from user_role_privs;
9 查看当前用户的系统权限和表级权限
SQL>select * from user_sys_privs;
SQL>select * from user_tab_privs;
10 显示当前会话所具有的权限
SQL>select * from session_privs;
显示指定用户所具有的系统权限
SQL>select * from dba_sys_privs where grantee=’GAME’;