Oracle User Creation And Authority[유저생성 및 권한]

2011.02.22 15:48DataBase/oracle

 

CREATE USER smartworks IDENTIFIED BY smartworks  --유저생

GRANT CONNECT, RESOURCE TO smartworks --리소스권한

GRANT CREATE SESSION TO smartworks --세션권한

GRANT CONNECT, DBA TO smartworks  --DBA권한 부여


DBA 권한 부여하기 싫으면, 테이블 CREATE, UPDATE , TRIGER, FUNCTION 생성 정도?

1 2 3 4 5 6 7 8 9 10 ··· 14