Was this helpful?
Modify a User
You modify users using the Modify User dialog (see User Dialog). You can access this dialog in the Instance Explorer in any of the ways explained in that topic.
To modify a user
1. In the Instance Explorer, open the Security folder for a connected installation.
2. Open the Users folder, right-click on the user node you want to change, and select Modify on the context menu.
The Modify User dialog opens (see User Dialog).
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. Select or change the default profile, if desired.
If no profiles have been created, this list will be blank.
3. Select or change the default group to assign the user to, if desired.
If no groups have been created, this list will be blank.
4. Specify whether the user’s access rights expire. If so, select an expiration date using the date picker.
5. Specify how the user’s password should be authenticated.
The first time the DBMS option is selected for a user, a warning message appears.
6. (Optional) If DBMS authentication is selected and you want to change the password, click Change Password.
The Change Password dialog opens.
Enter and confirm the new password for the user account, then click OK.
A message is displayed, indicating that the password will not be changed until you save changes by clicking OK on the Modify User dialog.
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 user-specific and default permissions for the user.
Select roles:
1. In the “Select a page” portlet, 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 or clear any 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.
Set miscellaneous options:
1. In the “Select a page” portlet, click Options.
Miscellaneous settings are displayed on the right side of the dialog. For more information, 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.
Last modified date: 04/24/2023