Kbase P26036: How can I change a password using Progress V9 SQL?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
GOAL:
How can I change a password using Progress V9 SQL?
GOAL:
How can I change an existing user's password using Progress V9 SQL?
FACT(s) (Environment):
Progress 9.x
UNIX
Windows
FIX:
The Progress SQL92 "ALTER USER" statement can be used to change a password for a specified user. The syntax is as follows:
ALTER USER 'username', 'old_password', 'new_password' ;
In the example below the "Jasper" user account password is change from "normandy" to "brittany".
ALTER USER 'Jasper', 'normandy', 'brittany';
COMMIT;