PL/SQL API jcs.change_password
Summary
Change the stored password for this user, and if desired the ORACLE password as well.
If password change propagation is activated, all schedulers that can be reached either via the network agent or directly, will be notified. They will check whether the password for that user was stored locally with the set connect internal statement. If this is the case, the locally stored password will be updated so that connect internal will use the new password.
note
These only change Redwood and ORACLE passwords. If you run process servers on Windows NT, there are also NT account passwords involved, but they must be changed using the Service Manager.
Privileges
You need ALTER_USER privilege to change someone elses password. If you want to change the ORACLE password, the SCHEDULER_SCHEMA must have ALTER_USER privilege. This is granted during process server installation, but may have been revoked by your DBA.
Specification
procedure change_password(username in varchar2,
password in varchar2,
rw_only in varchar2 default const.jcs_no)
Parameters
- username - the ORACLE username
- password - the ORACLE password
- rw_only - whether to change only the Redwood password. No means that the ORACLE password is changed as well (recommended).
Transaction keyword
The transaction keyword defines how and/or when the changes are committed to the database. A definition of the various transaction keywords can be found on the jcs package summary page.
commits
plsqlTopic
onsiteTopic