Progress
Database Administration
Guide and Reference


SQL-92 Tables Only

An SQL-92 database administrator (DBA) is a person assigned a sysdbauth record in the database. SQL-92 DBAs have access to all meta data and data in the database. To support Progress internal schema caching, every Progress database begins with a DBA defined as “sysprogress.” Progress restricts the use of “sysprogress,” however, and the process you follow to establish authentication depends on whether the database is newly created or created prior to Progress Version 9.0B.

In New Databases

When you create a new Progress 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-92 DBAs, and use the CREATE USER and DROP USER statements to add and delete user IDs.

In Earlier Databases

If your database was created earlier than Progress Version 9.0B and does not have any _USER records defined, then do the following:

  1. Log in as “sysprogress.”
  2. Designate another DBA user ID and use it to grant user-access privileges.
NOTE: Use the GRANT statement to designate other SQL-92 DBAs. For extra authentication protection through password checking, use the CREATE USER and DROP USER statements. For more information about the GRANT, CREATE USER, and DROP USER statements, see the Progress SQL-92 Guide and Reference .


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095