DBA와 DBA의 멤버는 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;