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