pvdbpass
Description
pvdbpass allows users to change their passwords for secure databases without administrator intervention.
Synopsis
The utility 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
The new password for the user. See Identifier Restrictions by Identifier Type in Advanced Operations Guide for password restrictions.
-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