User Designer

The User Designer is provided for administering user privileges on server, database, table, and column levels, as well defining various user properties. To design a new user double-click the Create user in design view item within the Profile Window | Users page. To design the existing user select its name within the Profile Window | Users page and click the Design button on the toolbar or in the popup menu.

The User Designer window provides two pages for designing user privileges and properties. The Privileges tab contains a tree list, which allows you to view and modify all basic user privileges (Select, Insert, Update, etc) for each access level (host, database, table, column). The Options tab allows you to edit user name, host, password, and set such properties, as Show Databases, Max Queries, etc.

The top level of the tree represents the current server. The second level is for databases. Note, that only current database is shown default, but you can view other databases by selecting the Show All Databases item from the popup menu of the list. The next two levels represent database tables and columns respectively. You can show or hide these levels using items Hide Tables and Hide Columns.

The list columns represent basic user privileges. A checked box in the cell shows that the user has the selected privilege for the selected object. An empty box shows that the user has no such a privilege, and the box with a square (or a grayed check box) shows that the privilege for the object is inherited from a top-level object. To edit privileges simply click in the appropriate cells to change the check values.

The popup menu of the Privileges tab provides the following functions for editing users:

Grant Full Access - assigns all privileges to the user;
Revoke All Privileges - removes all privileges from the user;
Grant Whole Object - assigns all privileges on the selected object to the user;
Grant Whole Privilege - assigns the selected privilege on all objects to the user;
Revoke Whole Object - removes all privileges on the selected object from the user;
Revoke Whole Privilege - removes the selected privilege on all objects from the user.

The Options tab allows you to define the user name, password, host, and set additional permissions.

The following user properties are available for editing:

User Name - the name of the user, which along with User Host must uniquely identify the user on the server.
User Host - specifies the host(s) from which user can access to the server.
Password - allows you to set a new password for the user, which should be confirmed within the Confirm Password box.
Basic permissions - this group sets additional server privileges to user.

All changes made to the user design takes effect only after the Apply button is pressed. If you want to discard all changes and revert to the last saved user design, click Revert.