Oracle中创建用户

create user yun3151 identified by yun3151 
default tablespace myschool
temporary tablespace temp


desc dba_users
select username from dba_users
where account_status='OPEN'


grant connect,resource to yun3151
revoke connect ,resource from yun3151


alter user yun3151 identified by yun
alter user yun3151 account unlock
drop user yun3151 cascade