skip to main content
SQL statements : DCL statements : CREATE USER
 

CREATE USER

This statement creates and configures a database user.
To support CREATE USER processing, the IP GETSUPPORT operation must return TRUE for IP_SUPPORT_CREATE_USER.
The OpenAccess SDK SQL engine recognizes the commands used to set up users and roles and passes the command information to the IP registered routine.

Syntax 

CREATE USER user [IDENTIFIED {BY password | EXTERNALLY}] [USERDATA 'string']

Examples

CREATE USER user1 IDENTIFIED BY welcome123
CREATE USER user2 IDENTIFIED EXTERNALLY