How to enable the "SYSPROGRESS" user in progress o

Posted by MiguelSaucedo on 29-Jul-2013 09:12

Hi guys, reading this article:

"The default DBA: 

The user who creates the database becomes the default DBA. This user can be used to set additional  database Administrator accounts. The sysprogress account is disabled by default. The sysprogress account  should be used only in cases where there is no other SQL-92 DBA. For example, if the database was  converted from a Progress Version 8.x database with defined users, create a sysprogress user to be able to  log in as a DBA in a SQL-92 database."

http://knowledgebase.progress.com/articles/Article/20143

How to enable the "SYSPROGRESS" user in progress open edge 10.1 B ?

Thanks in advance

Community Groups - Forum

All Replies

Posted by Marek Bujnarowski on 07-Oct-2013 08:15

Just create a user 'sysprogress' in Data Administration (Admin->Security-> Edit User List), choose password then use it with SQL client (ODBC/JDBC).

Posted by Youssif Shanshiry on 14-Nov-2013 13:07

Alternatively, create the sysprogress user programmatically by running 4GL/ABL procedure similar to the following:

DEFINE VARIABLE cUserName AS CHARACTER   NO-UNDO.

DEFINE VARIABLE cPassword AS CHARACTER   NO-UNDO.

ASSIGN

   cUserName = "sysprogress"

   cPassword = ENCODE("Your_Sysprogress_Password").

/* Delete the sysprogress user record if it exists */

FIND _User WHERE _User._Userid = "sysprogress" EXCLUSIVE-LOCK NO-WAIT NO-ERROR.

IF AVAILABLE _User THEN

   DELETE _User.

/* Create the sysprogress user record */

CREATE _User.

ASSIGN

   _userid   = cUserName

   _password = cPassword.

This thread is closed