1. Click Database Administration > Go to Database Administration in the OpenEdge Management console menu.
The Database Administration page appears.
2. Filter or search for, and select the required database connection.
The database connection home page appears.
3. Click Edit users in the Security Summary section.
A list of existing database users appears in a grid in the Edit Database Users page. If you have a large number of users, you can move forward or backward a page, or specify a particular page, in the list of users by using the Page feature at the bottom of the list.
The list provides the following details:
User ID — The ID assigned to the user.
User Name — The user name.
Domain Name — The domain to which the user belongs.
SQL Only — If this option is enabled, the _user table record can be used only by a SQL connection to authenticate to the database. ABL clients cannot authenticate to the database by using user ID and user name.
If the option is disabled, both SQL and ABL users can use the record.
Description — Provide a description or notes about a particular user.
4. Click New.
5. Provide the following information for the new user:
User name — Type the user's name (required). Do not use spaces or special characters such as an asterisk (*), ampersand (&), or a period ( . ) in this field. You can include the underscore (_).
Domain name — Enter a domain name or click the Search icon to open the Domain Selection dialog to select a domain name (required).
The Domain Selection dialog displays the details of the domains in a grid. You can search or filter the domains in the grid by Domain name and/or Tenant name.
You can also move forward or backward the page, or specify a particular page, in the list of domains by using the Page feature at the bottom of the grid.
You can select the column heading and click the drop-down to choose the order (ascending or descending alphabetically) for the domains to appear in the grid.
Password — Type the user's password.
Confirm password — Retype the user's password.
SQL Only — Select the check box to indicate that the _user table record can be used only by a SQL connection to authenticate to the database.
If the check box is enabled, ABL clients cannot authenticate to the database by using user ID and user name.
If the check box is disabled, both SQL and ABL users can use the record.
User number — Provide a number to identify the user (optional). The number must be a positive integer.
Description — Provide a description (optional).
Given name/Middle initial/Surname — Provide the user's given name, middle initial, and surname (optional).
Telephone — Type the user's telephone number (optional).
E-mail — Type the user's email address (optional).
User ID — The ID assigned to the user.