Feedback
Did this article resolve your question/issue?

   

Article

How do I run a SQL script to create SQL-92 users

« Go Back

Information

 
TitleHow do I run a SQL script to create SQL-92 users
URL NameP124481
Article Number000145411
EnvironmentAll Supported Operating Systems
OpenEdge 10.x, 11.x
Progress 9.1x
Question/Problem Description
How do you add a user to the _user table from SQL Explorer?
How do you create a user from SQL Explorer?
How do I run a SQL script to create SQL-92 users
How to create a new SQL92 user
How to create SQL92 users for databases on UNIX machine itself
How to create SQL-92 users without a SQL explorer on Windows
Steps to Reproduce
Clarifying Information
Error Message
Defect Number
Enhancement Number
Cause
Resolution
To create SQL-92 users any SQL-92 client can be used.
Progress provides a tool called SQL Explorer that can be used for Administrative purposes.

To create a SQL-92 user the following commands are needed:

CREATE USER '<username>','<password>';
GRANT <role> to  '<username>';
COMMIT;


The 'userid' and 'password' must be enclosed in quotes and separated by a comma.
The user executing this statement must have DBA privileges.

Use SQL Explorer (on Windows) or sqlexp on the command line (on Unix) connected as owner of the database or as sysprogress.

The following steps can be used to create a SQL script file containing the above commands to be executed in SQl Explorer.

1. Create a file, e.g named "users.sql", containing the following SQL92 statements

CREATE USER '<username>','<password>';
GRANT DBA to '<username>';
COMMIT;


2a. Execute sql explorer on CHAR mode running the following command:

sqlexp -char -db <database> -S <service> -user sysprogress -password sysprogress -infile users.sql

OR

2b. Start a sqlexp session:

sqlexp -char -db <database> -S <service> -user sysprogress -password sysprogress 
     and execute:
@RUN users.sql


IMPORTANT: Progress recommends creating minimum of one user with DBA privilege.
Workaround
Notes
References to Written Documentation:

SQL-92 Guide and Reference
Last Modified Date9/13/2015 5:01 AM
Attachment 
Files
Disclaimer The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information.

Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an "AS IS" basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.