User 생성과 관리

실습 : User 생성과 관리

 

SQL> create user bob  

         identified by bob  

         default tablespace test  

         temporary tablespace temp  

         quota 1m on test;

         User created.

 

 

SQL> create user kay
  2  identified by abcd
  3  default tablespace test
  4  temporary tablespace temp;

 

SQL> select username,default_tablespace,temporary_tablespace from dba_users
 where username in ('BOB','KAY')

 

 

SQL> select * from dba_ts_quotas;

SQL> drop user kay;

User dropped.

SQL> alter user bob
  2  password expire;

User altered.

 

 

SQL> conn bob/bob / bob user 접속