Previous Topic: ALTER USER ParametersNext Topic: ALTER USER More Information

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

ALTER 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.

Changing the Default Group and User Profile

The following ALTER USER statement specifies a new default group and user profile for user sue:

alter user sue
  group hr_corp
  profile hr_prof;