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

CREATE USER PROFILE Usage

Nesting Profiles

The attribute keyword INCLUDE specifies that attribute-value identifies another profile. The attributes of the included, or nested, profile are added to those of the current profile.

Up to 10 levels of nesting are supported.

Substitution Parameters

The value of a substitution parameter in attribute-specification:

• Must not exceed 32 characters, including a prefix and suffix
• Must not contain special characters other than @, $, and #

The following CREATE USER PROFILE statement creates a profile with two attributes:

create user profile corp_dev
  attributes
    dept='1237',
    prtdest='gdnc03';