Micro Focus Enterprise Developer 3.0 for Eclipse > Programming > Mainframe Programming > SQL Option for DB2 > Reference > SQL Reference > SQL Statements > CREATE USER

CREATE USER

The CREATE USER statement enables you to create additional XDB user accounts.

Restriction: This topic applies to Windows environments only.

Syntax

CREATE USER username 
         TYPE [ USER | SUPERUSER ] 
         PASSWORD password REQUIRED [ YES | NO ] 
         option_list

option-list:

SECONDARY ID authid 
        GROUPS group_list 
        PRIORITY priority 
        ACCESS AUTHORITY [ YES | NO ] 
        COMMENT quoted-string

Description

Requirements for XDB passwords can be controlled on an XDB user basis. ACCESS AUTHORITY set to NO completely disables an XDB user id. The SECONDARY ID, GROUPS, and PRIORITY concepts are all discussed in the section System Level Access Control in the Security and Authority chapter in your SQL Option Server Administration Guide