Consultor Eletrônico

Status: Verified

GOAL:

How to create a non-default dba user to access 4GL Tables from a SQL-92 Client

GOAL:

If the default DBA gets deleted is there a way to re-create it without re-creating the database?

GOAL:

Privileges required for accessing 4GL Table from SQL-92 Client

FIX:

Here are the steps to accomplish this:

1. Connect to the database using Data Administration tool
2. Choose "Admin" > Security > "Edit User List"
3. Create Progress default DBA user "sysprogress" as a user ID. Assign a password, for example, "x".
4. Connect to the Progress SQL Explorer using the above user name and password.
5. Create a user and password and grant DBA privilege to that user using the following SQL:

To create a user:

create user 'test', 'test';
commit;

Where the first "test" is the user name and second "test" is the password.

grant dba to test;
commit;

These above SQL should create a user with dba privilege.

6. You can now delete the user "sysprogress" you created in step 3 by going through the Progress "Data Administration" tool. The user you created in step 5 can be used to create more user with different privilege settings.