To create a user account:
- Connect to a database as a user who has DBA privileges.
- Choose the Security node in the DB Structure view.The Security tab becomes active in the DB Details view.
-
Click Add user to database
in the Security tab.The Create user dialog appears.
-
Type a user ID.The user ID can contain a maximum of 32 characters and cannot
contain any blanks
Note: Once a user is created, you can log in to DB Navigator only with a defined user ID.
-
Type a password and confirm it. Passwords are optional. If you create a
password, it can contain a maximum of 32 characters and cannot contain any
blanks.
Note: The password is case-sensitive; user IDs are not case-sensitive.
-
Choose to grant either DBA or RESOURCE privileges for the user.
Note: If you create a user account for an OpenEdge database that has no user accounts defined, make sure that the first account you create has DBA privileges. If the first account does not have DBA privileges, you cannot add a DBA account or any additional user accounts. In SQL, DBA and RESOURCE are database-wide privileges that can be assigned to individual users.Users with DBA privileges have the ability to access, modify, or delete a database object and grant privileges to other users. RESOURCE privileges are limited compared to DBA privileges. Users with RESOURCE privileges can create database objects, but cannot modify or delete database objects. They cannot grant privileges to other users.
-
Click Create. This generates a SQL script that is
executed and committed.
The new user appears in the list in the Security tab and is added to the _User table.