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