- 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;
댓글 없음:
댓글 쓰기