Oracle数据库命令速查手册-Managing users 

1.create a user: database authentication
sql> create user juncky identified by oracle default tablespace users temporary tablespace temp quota 10m/unlimited on data password expire [account lock|unlock] [profile profilename|default]; 
2.change user quota on tablespace 
sql> alter user juncky quota 0 on users;
3.drop a user 
sql> drop user juncky [cascade]; 
4. monitor user 
view: dba_users , dba_ts_quotas

posted on 2015-02-09 22:34  RainbowGu  阅读(88)  评论(0)  编辑  收藏  举报

导航