pvdbpass

---

pvdbpass - Pervasive database password utility.

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] 

Description

pvdbpass allows users to change their passwords for secure databases without administrator intervention.

Parameters

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. The password is subject to the limitations specified in the SQL Engine Reference. See the SET PASSWORD syntax. Note: If the new password begins with a non-alphabetic 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)
servername	Optional. Server name on which the database is defined. If you do not specify this option, the local machine is assumed
port	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

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