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