페이지

2014년 4월 10일 목요일

[altibase]create user

  • create user
CREATE USER TMPADM IDENTIFIED BY TMPADM
DEFAULT TABLESPACE TS_TMP_DISK_DAT 
ACCESS TS_TMP_DISK_DAT ON
ACCESS TS_TMP_DISK_IDX ON 
ACCESS TS_TMP_MEM_DAT ON;


  • grant access to tablespace
alter user TMPADM access TS_TMP_DISK_DAT on;
alter user TMPADM access TS_TMP_DISK_IDX on;
alter user TMPADM access TS_TMP_MEM_DAT on;


  • change user password

ALTER USER TMPADM IDENTIFIED BY 1234;

댓글 없음:

댓글 쓰기

image

image