查看用户系统权限: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;