Creating users and roles

The OpenAccess SDK SQL engine supports defining users and roles. In the current version, 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.

Command Syntax

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

The USERDATA keyword allows specifying database specific information.

DROP USER user

CREATE ROLE role

DROP ROLE role