skip to main content
Designing and coding the IP : Privileges : Creating users and roles
 

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