Tables used from SQL only
- Last Updated: February 11, 2026
- 1 minute read
- OpenEdge
- Version 13.0
- Documentation
Tables used from SQL only
An SQL Database Administrator (DBA) is a person assigned a sysdbauth record in the database. SQL DBAs have access to all meta data and data in the database. To support internal schema caching, every OpenEdge database begins with a DBA defined as "sysprogress." However, OpenEdge restricts the use of "sysprogress."
When you create an OpenEdge database using the PROCOPY or PRODB commands,
and the database does not have any _User records
defined (from the source database, for example), then a DBA is automatically
designated with the login ID of the person who creates the database. This
person can log into the database and use the GRANT statement
to designate additional SQL DBAs, and use the CREATE USER and DROP
USER statements to add and delete user IDs. When creating
users, this DBA can also specify users as SQL-only users, who can
only access the database through SQL.