사용자 관리

설명

 DBADBA의 멤버는 SQL 문을 사용하여 사용자를 생성, 변경, 삭제할 수 있다.

구문

CREATE USER user_name
[ PASSWORD password ]
[ GROUPS user_name [ {, user_name } ... ] ]
[ MEMBERS user_name [ {, user_name } ... ] ] ;
DROP USER user_name;
ALTER USER user_name PASSWORD password;

예제

CREATE USER Fred;
ALTER USER Fred PASSWORD '1234';
DROP USER Fred;

CREATE USER company;
CREATE USER engineering GROUPS company;
CREATE USER marketing GROUPS company;
CREATE USER design GROUPS company;
CREATE USER smith GROUPS design, marketing;
CREATE USER jones GROUPS marketing;  
CREATE USER brown GROUPS engineering;

CREATE USER company;
CREATE USER brown;
CREATE USER jones;
CREATE USER engineering MEMBERS brown;
CREATE USER marketing MEMBERS smith, jones;
CREATE USER design MEMBERS smith;CREATE USER smith;