LucidDbCreateUser

From Eigenpedia

Jump to: navigation, search

Syntax

CREATE USER user-name
AUTHORIZATION { authorization 'unused' | identified by 'password' }
[ DEFAULT { CATALOG | SCHEMA } default-namespace ]

Example

Basic:

CREATE USER scott 
identified '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;
Personal tools