SQL - CREATE USER

(Since v2.2)

Creates a user in the current database, with the specified password and an optional role. Note that if a role isn't specified, a default role ("writer") is used.

Note this is simply a wrapper around OUser and ORole tables; Look up Security for more details.

Syntax

CREATE USER <user-name> IDENTIFIED BY <password> [ROLE <role-name>]

WHERE:

  • role-name is the name of the role. To specify multiple roles pass an array of names. Example: ROLES ['author','writer']

Examples

Creates a new user called 'Foo', with password 'bar', and role 'admin'

create user Foo identified by bar role admin

Creates a new user called 'Bar', with password 'Foo'

crete user Bar identified by Foo

To know more about other SQL commands look at SQL commands.

References