Programs Knowledge

create user <使用者名稱>
identified by <Password>
default tablespace<tablespace_name>
temppotary tablespace<tablespace_name>
quota<space_size>

#如果沒定義tablespace預設都是system
新增
    create user horace
    identified by xxxx123
    default tablespace mis_space
    quota 50M on mis_space
修改
   alter user <user_name>
   identfied by <password>
   default tablespace <tablespace>
   temporary tablespace <tablespace>
   quota <space_size>

通長一個新的user會給下面權限

grant connect,resource,create view,alter session,create synonym to horace

############ 更改密碼 #################
ALTER USER SCOTT IDENTIFIED BY TIGER;

############## scott 被locke ###############
select account_status,lock_date,profile from dba_users
where username='SCOTT';

ACCOUNT_STATUS                   LOCK_DATE PROFILE
-------------------------------- --------- ------------------------------
LOCKED                           17-JAN-08 DEFAULT

alter user scott account unlock;