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
**********************************************
对于一件事情,往往超过我们的想象,自信、坚持,勇往直前!
参与者:Rainbow Gu
地址:南都
***********************************************