Kbase P131207: SQL: How to programmatically change a Progress database user password?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
18/09/2009 |
|
Status: Verified
GOAL:
SQL: How to programmatically change a Progress database user password?
GOAL:
Who can change Progress database users' passwords and how using SQL?
GOAL:
Can I change my own password using SQL?
GOAL:
Can I change another Progress database user password using SQL?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
1. Any user can change their own password. For example, user "Jasper" can change his existing password from 'spaniel' to 'NewPassword' by executing the following ALTER USER SQL statement:
ALTER USER 'Jasper', 'spaniel', 'NewPassword'
2. A DBA can change another user password ONLY by deleting and re-creating the user's record in the _User table. For example, the DBA may change the password of user 'Jasper' from 'spaniel' to 'NewPassword' by executing the following two SQL statements:
DROP USER 'Jasper'
CREATE USER 'Jasper', 'NewPassword'