Command Line Interface Utilities : pvdbpass
 
pvdbpass
Description
The pvdbpass tool allows users to change their passwords for secure databases without administrator intervention.
Synopsis
The tool will prompt for the passwords with this syntax
pvdbpass database username [-server name] [-port number]
This syntax includes the old and new passwords.
pvdbpass database username password newpassword
[-server name] [-port number]
Options
 
database
Database in which the username is defined (this can be a database name or a server DSN)
username
The user whose password will be changed.
password
The current password for the user. You must provide the original password in order to modify it. You can either provide the password as a parameter or omit it and be prompted.
newpassword
The new password for the user. See Identifier Restrictions by Identifier Type in Advanced Operations Guide for password restrictions.
Note: If the new password begins with a nonalphabetic character, the password must be enclosed in single quotes. If the existing password begins with a non-alphabetic character, do not enclose it in single quotes (see examples).
-server name
Optional. Server name on which the database is defined. If you do not specify this option, the local machine is assumed
-port number
Optional. TCP port on which the SQL engine running on servername is listening. If you do not specify this option, the default port 1583 is assumed. See also Changing the Default Communication Ports in Getting Started with PSQL.
Examples
To change the Master user's password and be prompted:
pvdbpass demodata Master
To change an existing password to one that does not start with an alphabetic character (use single quotes):
pvdbpass demodata Joe oldpassword '123'
To change a password on a remote server:
pvdbpass demodata Joe oldpass newpass -server finance1