Kbase P12130: How to create SQL92 users for UNIX databases on UNIX machine itself?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
07/04/2004 |
|
Status: Verified
GOAL:
How to create SQL92 users for UNIX databases on UNIX machine itself?
GOAL:
If I don't have SQL explorer on Windows, how do I create SQL-92 users for UNIX databases?
GOAL:
How do I run a SQL script to create SQL-92 users on UNIX?
FACT(s) (Environment):
Progress 9.x
FACT(s) (Environment):
UNIX
FIX:
The owner of the database will be able to start a SQL92 client such as sqlexp and create the first SQL92 users for that database.
1. Have a SQL script, named "users.sql", containing the following SQL92 statements
CREATE USER 'sysprogress','sysprogress';
GRANT DBA to 'sysprogress';
COMMIT;
CREATE USER 'myself','mypass';
COMMIT;
2. Run the command
sqlexp -char -db <database> -S <service> -infile users.sql
The privilege user 'sysprogress' and the user 'myself' will be created.
The following SQL92 connections will always require a username and password, as per example:
sqlexp -char -db <database> -S <service> -user sysprogress -password sysprogress
IMPORTANT: Create minimum one user with DBA privilege. In the sample above, only "sysprogress" has DBA privilege.