Privileges assigned by the SQL database administrator are enforced only when the user accesses the database through a SQL client. If a user can access the database through either the SQL or ABL clients, ensure that the user is granted identical SQL privileges and ABL permissions.

To check the users who have database administrator privileges for SQL within the OpenEdge database, view the list in the Database Authorization table. Use the following command to see the SQL view of the Database Authorization table:
select * from sysprogress.sysdbauth
The following is an example of the result fetched by the command: 
GRANTEE                          DBA_ACC  RES_ACC
-------------------------------- -------  -------
administrator                       y        y
SYSPROGRESS                         y        y
In the result:
  • administrator–The administrator username corresponds to the user who created the database.
  • SYSPROGRESS–The SYSPROGRESS account is used internally by the SQL engine.
  • DBA_ACC–The column DBA_ACC corresponds to the database administrator access that a user can have.
  • RES_ACC–The column RES_ACC corresponds to the resource access, which means permission to create objects in the database.
Note: If you revoke the database administrator from any of these permissions, the username remains in the sysprogress.sysdbauth view. However, the permission is displayed as blank.