Consultor Eletrônico

Status: Unverified

GOAL:

Which login ID designates me as DBA (procopy, prodb)?

FIX:

Extract from the Database Administration Guide and Reference:

"8.1.3 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 prior to 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:

· Use the Data Dictionary to designate a 4GL DBA user ID and use it to grant access privileges.

· 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."

The login ID is your NT or UNIX user ID, the one you login to the system with. You can check this by creating a new database, proserve and then connect to it from SQL Explorer. Run the command:

select * from sysprogress.sysdbauth

You will see your user ID and sysprogress as DBAs.