oracle 설정
user 생성 삭세
초이짬
2016. 1. 11. 16:15
728x90
CREATE USER user1 IDENTIFIED BY pass1
DEFAULT TABLESPACE [테이블스페이스명]
--TEMPORARY TABLESPACE BEANY_TMP 임시 테이블
--PROFILE DEFAULT
ACCOUNT UNLOCK;
grant resource to juser1;
grant connect to juser1;
grant create view to juser1;
grant create synonym to juser1;
drop user [유저명] cascade;
728x90