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