CHANGE_ACCESS_PASSWORD

Syntax

CHANGE_ACCESS_PASSWORD SymbolicID newAccessPswd

The following special characters do not work for database passwords:

  • double quote(")

  • forward slash (/)

  • single quote (‘)

  • at sign (@)

  • backquote (`)

  • backslash (\)

Description

Use this command to reset the access password and make it transparent to users.

The CHANGE_ACCESS_PASSWORD command performs the following operations:

  • Selects the access password field from the PSACCESSPROFILE table for the specified symbolic ID.

  • Changes the access ID's database password to the new access password that you specify (for Oracle and Microsoft SQL Server only).

  • Updates the PSACCESSPROFILE table for the specified symbolic ID with the new access password.

Parameters

LOG and NO TRACE