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:
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 |