LucidDbCreateUser

From Eigenpedia

Jump to: navigation, search

Syntax

CREATE USER user-name
AUTHORIZATION jaas-authentication-expression
[ DEFAULT { CATALOG | SCHEMA } default-namespace ]

Example

Basic:

CREATE USER peon 
AUTHORIZATION 'Unused';

Advanced:

CREATE USER vice_dba
AUTHORIZATION 'Unused' 
DEFAULT SCHEMA sys_root;
Personal tools