Kbase P163831: 4GL/ABL/SQL: We do not have user names in the database. Is there a parameter that will put these i
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/14/2010 |
|
Status: Unverified
GOAL:
4GL/ABL/SQL: We do not have user names in the database. Is there a parameter that will put these in?
GOAL:
How can we create users in a Progress or OpenEdge database?
GOAL:
How to create database users using the Data Administration Tool?
GOAL:
How to programmatically create database users using 4GL/ABL?
GOAL:
How to programmatically create database users using SQL?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
There are three ways to create users in a Progress/OpenEdge database:
1. Using the Progress/OpenEdge Data Administration Tool.
a. Start a proenv session.
b. Start the Data Administration Tool using the command:
prowin32 sports2000 -1 -p _admin (On UNIX, use pro or mpro)
c. Select: Admin | Security | Edit User List | Add and fill the requested fields.
2. Programmatically using the 4GL/ABL language: For example, the following 4GL/ABL procedure, if executed from a Procedure Editor or a 4GL/ABL client session connected to an OpenEdge or a Progress database, creates a user in that database with the following details: User ID = SomeId, User Name = SomeName, Password = SomePwd:
CREATE _User.
ASSIGN
_User._Userid = "SomeID"
_User._User-Name = "SomeName"
_User._Password = ENCODE("SomePwd").
3. Programmatically using SQL: For example, the following SQL CREATE statement, if executed from an ODBC or a JDBC client connected to an OpenEdge or a Progress database, creates a user in that database with the following details: User ID = SomeId, User Name = SomeName, Password = SomePwd:
CREATE USER 'SomeID', 'SecretPwd';