Authorization is the process by which DBAs (or Security Administrators for ABL) enable users to perform tasks on the database, such as retrieving, updating and deleting information. OpenEdge SQL and ABL each employ their own mechanism for performing authorization.

OpenEdge SQL performs authorization through the GRANT statement. ABL database administrators (initially) and Security Administrators (primarily) authorize users to perform database tasks using Database Administration. In addition, ABL programmers can use the same permissions mechanism to authorize access to application functions.

For more information on defining and using authorization permissions through Database Administration and ABL, see Learn about Identity Management, Manage the OpenEdge Database, and Introduction to OpenEdge Management.

Note: OpenEdge supports authorization based on a fully qualified user ID only for access to multi-tenant databases. For non-multi-tenant databases, even if you authenticate access to a database connection using a fully-qualified user ID, OpenEdge authorizes access based only on the non-qualified user ID (user name).