查看用户系统权限:
select * from dba_sys_privs;
select * from session_privs;
select * from user_sys_privs;
查看用户对象权限:
select * from dba_tab_privs;
select * from all_tab_privs;
select * from user_tab_privs;
修改数据库密码:alter user ** identified by ***
select sid,serial# from v$session where username='TEST';
select sid,serial# from v$session where username='test';
alter system kill session '150,9019';
管理员账号建立:
drop user dipbps cascade;
      create user dipbps identified by deppon##_dipbpstest120;
      grant dba to dipbps;