Usually, the user who creates the OpenEdge database is configured as the default database administrator of that database. Additionally, there is a stub user account known as the sysprogress account.

The sysprogress user account is a SQL database administrator account that has access to all database tables. You can create this account within the _user table. You can use this account to log in to the SQL engine and run SQL statements or perform administrative operations on the SQL part of the OpenEdge database.

Note: Any rights that are granted, revoked, altered, and committed persist even when the sysprogress account is removed from the _user table.

Create a sysprogress account

To create a sysprogress account, perform the following steps:
  1. Click Start > Progress > Data Administration. The Database Administration window appears.
  2. Click Database > Connect. The Connect Database window appears. Fill in the database connection details and click Ok. The Connect Database window disappears.
  3. In the Database Administration window, click Admin > Security > Edit User List.... The Edit User List window appears.
    Note: The administrative menus, such as Admin, DataServer, Utilities, and so on in the Database Administration tool are available only when OpenEdge is running with a Development license. If these menus appear grayed out, verify that a valid Development license is installed before proceeding.
  4. In the Edit User List window, click Add.... The Add User window appears. Enter sysprogress in the User ID and User Name.
  5. Assign a password to the sysprogress user and click Ok. In the Edit User List window, click Ok. You have now created a sysprogress account.