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

ALTER 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 ALTER USER PROFILE statement defines two attributes in an existing profile:

alter user profile corp_dev
  attributes
    dept='5621',
    prtdest='wwuav';