You can create users in the _user table by the CREATE USER statement.

When users are created in the OpenEdge database, the default database administrator (the user who created the database) is disabled. It is important to grant database administrator rights to at least one user so you have a valid database administrator account.

Syntax

Use the following syntax for the CREATE USER statement:
CREATE USER {'username'|'username@domain_name'}, 'password';

Examples

In the following example, an account with database administrator privileges creates the username GPS with password star.
CREATE USER 'GPS', 'star';
The following example creates one database administrator account and two regular user accounts. 
create user 'dba1','password';
grant dba to 'dba1';
create user 'user1','x';
create user 'user2','x';
commit;
Note:
  • If you have disabled AutoCommit when using the SQL Explorer tool, remember to commit these or any other changes.
  • Many third party ODBC interface do not need a commit statement because in ODBC, AutoCommit is enabled by default.
  • Permissions granted or revoked from the SQL side only apply to users that access the database using SQL.

Absence of privileges

If you do not have any privileges to access SQL objects, perform the following steps:
  1. Open the SQL Explorer and connect as 'sysprogress' (no password).
  2. Grant database administrator privilege to the desired user by the following command:
    GRANT DBA TO 'user';
   COMMIT;
Note: This command will work only if you have created a sysprogress account.

For more information, see CREATE USER.