How to enable the "SYSPROGRESS" user in progress open edge 10.1 B ? - Forum - Community Groups - Progress Community

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

 Forum

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

  • 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

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

  • 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.