Kbase P111005: How do you create a user in SQL Explorer?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/10/2009 |
|
Status: Unverified
GOAL:
How do you add a user to the _user table from SQL Explorer?
GOAL:
How do you create a user from SQL Explorer?
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
FIX:
Use the CREATE USER statement:
CREATE USER 'userid','password';
COMMIT;
The 'userid' and 'password' must be enclosed in quotes and separated by a comma.
The user executing this statement must have DBA privileges.