User Guide : 10. Administering Users, Groups, Roles, and Profiles : Creating Users, Groups, Roles, and Profiles : Create a New User
 
Share this page                  
Create a New User
You create users using the New User dialog (see User Dialog). You can access this dialog in one of the following ways in the Instance Explorer:
• From the Users folder context menu: New User
• From an existing user node context menu: New User
• From the Database menu tab: User, New User (see Database Tab)
Note:  To assign the user to a profile or group, you must create the profile or group first. For more information, see Create a New Profile or Create a New Group. To assign a role to the user, you must create the role first: see Create a Role.
To create a new user
1. Open the New User dialog in one of the ways described previously.
The New User dialog opens.
Set general options:
1. In the “Select a page” portlet, click General.
General options are displayed on the right side of the dialog. For more information, see General Page (User).
2. Enter a unique, valid name for the user.
For more information about naming conventions, see Object Naming Rules.
3. Select a default profile, if desired.
If no profiles have been created, this list will be blank.
4. Select a default group to assign the user to, if desired.
If no groups have been created, this list will be blank.
5. Specify whether the user’s access rights expire. If so, select an expiration date using the date picker.
6. (Optional) Specify how the user’s credentials should be authenticated. If you selected DBMS, enter and confirm the user's password.
Set privileges:
1. In the “Select a page” portlet, click Privileges.
Privilege settings are displayed on the right side of the dialog. For more information, see Privileges Page (User).
2. Set the requested and default permissions for the user.
Select roles:
1. In the “Select a page” pane, click Roles.
Any defined roles are displayed on the right side of the dialog. If no roles have been created, this pane will be blank. For more information, see Roles Page (User).
2. Select any desired roles for the user.
Set access options:
1. In the “Select a page” portlet, click Access.
Access settings are displayed on the right side of the dialog. For more information, see Access Page (User).
2. Select the non-granted databases the user should have access to.
To select all listed databases, check “The user has access to the entire installation.”
Set miscellaneous options:
1. In the "Select a page" portlet, click Options.
Miscellaneous settings are displayed on the right side of the dialog (see Options Page (User)).
2. Specify whether the user has remote command privileges.
3. Specify whether security auditing is enabled for all events and query text.
Save your changes:
Click OK to save your changes.
The new user appears under the Users folder in the Instance Explorer.