Progress
Database Administration
Guide and Reference


Both 4GL and SQL-92 Tables

When your database contains both 4GL and SQL-92 tables, the process you follow to establish authentication depends on whether the database is a new Progress database or a database created earlier than Progress Version 9.0B, with and without _USER records defined.

In New Databases

When you create a new Progress database using the PROCOPY or PRODB commands, your login ID is used to automatically designate you as DBA, but only if there are no predefined_USER records or DBAs (other than “sysprogress”) in the source database.

Then, as creator of the new database, you can:

In Earlier Databases Without User Records Defined

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. Use the GRANT statement to designate another SQL-92 DBA and to grant user-access privileges.
In Earlier Databases With User Records Defined

If your database was created earlier than Progress Version 9.0B and has _USER records defined, you must use the 4GL DBA permissions to create a “sysprogress” user ID and password. Only then can you access the database from SQL-92 and use the GRANT statement to create SQL-92 DBAs. The SQL-92 DBAs must have corresponding _USER records for them to log in to the database successfully.

NOTE: Once you add one _USER record to a Progress database, a user ID and password is then required by anyone who wants to access the database. Consequently, first create all DBAs and be sure that at least one has a _USER record, then add additional user IDs.


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