Feedback
Did this article resolve your question/issue?

   

Article

SQL: How to change a Progress/OpenEdge user's password?

« Go Back

Information

 
TitleSQL: How to change a Progress/OpenEdge user's password?
URL NameP131207
Article Number000160070
EnvironmentProduct: Progress
Version: 9.x
Product: OpenEdge
Version: All Supported Versions
OS: All Supported Platforms
Question/Problem Description

SQL: How to programmatically change a Progress database user password?
Who can change Progress database users' passwords and how using SQL?
Can I change my own password using SQL?
Can I change another Progress database user password using SQL?
 
Steps to Reproduce
Clarifying Information
Error Message
Defect Number
Enhancement Number
Cause
Resolution

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';
COMMIT;

Prior to OpenEdge Release 11.0:
  • A DBA user can change another user's 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';
COMMIT;
Note:​ When a user is dropped, their access permissions are left intact.  Therefore when the user is re-created all of the permissions previously granted to them are automatically still available.  If the DB wishes to revoke these permissions she would use the SQL REVOKE statement.  See article How to revoke a SQL92 user right to update the database? for more details.

In OpenEdge Release 11.0 and later:
  • A DBA user can execute the ALTER USER syntax as specified above for any user.
In Progress Version 9:
  • This change can be done using the Progress SQL Explorer(GUI) utility.  However, when using the Progress SQL Explorer utility, be sure to select the "Auto Commit Transactions" menu option under "View-> Options" or use the SQL 'COMMIT' statement to be sure the change is permanent.
Workaround
Notes

References to Other Documentation:
Progress Article(s):
How to revoke a SQL92 user right to update the database?
 
Last Modified Date4/18/2018 6:47 PM
Attachment 
Files
Disclaimer The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information.

Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an "AS IS" basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.