LucidDbCreateUser

Syntax

CREATE USER user-name
[ AUTHORIZATION 'unused' | IDENTIFIED BY 'password' ]
[ DEFAULT { CATALOG | SCHEMA } default-namespace ]

Example

Basic:

CREATE USER scott 
IDENTIFIED BY 'tiger';

Creates a user named SCOTT in the catalog that uses the password "tiger" to login.

Basic JAAS:

CREATE USER peon 
AUTHORIZATION 'Unused';

Advanced JAAS:

CREATE USER vice_dba
AUTHORIZATION 'Unused' 
DEFAULT SCHEMA sys_root;

JAAS means: Java Authentication and Authorization Service and is pronounced 'jazz'.