Online Documentation for All SQLManager.net Products

User Manager
Top  Previous  Next


User Manager is provided for administering users and their global privileges.

To open the User Manager select the Tools | User Manager menu item.

userplus   Add User
Opens the User Editor for adding a new user.

useredit   Edit User
Opens the User Editor for editing the selected user's global privileges.

userminus   Delete User
Deletes the selected user.

The users list is displayed at the left side of the window. At the right there is a grid displayed with databases and the global privileges for them.

To modify the user's access grants, select the user from the list, select the database, right-click in grid to change the access grants for statements Read, Insert, Update, Delete, Create, Alter and Drop. Select the Grant item from the popup menu to permit an action, or the Revoke item to forbid.