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
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