Oracle 用户管理

1.创建用户

create user ok identified by ok;
grant create session to ok;

2.修改用户密码

alter user ok identified by ok1;

3.查看用户信息

select * from dba_users;

4.找出和用户相关的线程

 select sid,serial#,username from v$session;
 select sid,serial#,username from v$session where type='user';

5.终止要被删除的用户的相关回话

 alter system kill session 'sid,serial#';

6.查看该用户拥有的模式

 select owner,object_name from dba_objects where owner like ' ok';

7.删除用户

 drop user ok;
 
 drop user ok cascade;// 删除用户之前，先删除用户的模式下的对象