Syntax for Securing Global Resources › CREATE USER › CREATE USER Usage

CREATE USER Usage

Null Password

If password is NULL and CA IDMS internal security is used to validate users, the user will be able to sign on to a system without supplying a password.

Creating a Named User

This statement creates a user ID for an individual:

create user tim
  name 'Thomas McNall'
  password qwerty
  profile dev_prof;

Creating a Generic User

This statement creates a user ID for a given role:

create user dca_s18
  description 'Administrator for System 18'
  group dca_group
  password s18pass;