The User Permissions View displays the list of the user database object permissions, the list of roles assigned to this user, and the SQL script required to reproduce all these permissions. This view can be opened in the read only mode for the properties viewing and in the editor mode to modify the selected user privileges.
To open the User Permissions View in the read-only mode, select the user under Users folder in the Object Explorer and choose Properties popup menu.
To open the User Permissions View in the editing mode, select the user under Users folder in the Object Explorer and choose Edit Permissions popup menu.
The Permissions tab
The Permissions tab displays the list of all database object permissions assigned to the selected user.
Permissions For dropdown list box in the top area of the panel allows to filter object permissions by a specific object type, for example display permissions only for stored procedures or only for tables.
Using the popup menu, you can sort this list by object name, permission type, grantor or special column.
If this view is opened in the editor mode, you can add new object permissions using the Permission Wizard and delete selected permissions.
The Roles tab
This tab shows the list of roles assigned to the user.
If this view is opened in the editor mode, you can add new roles to the user using the Permission Wizard and delete selected roles.
To create new privileges, use Add popup menu to open Permissions Wizard.
To delete existing object privileges, select these privileges in the list and use Revoke popup menu.
The SQL tab
The SQL tab displays SQL GRANT statements, required to recreate all existing user privileges.
Use popup Select All and Copy menus to copy the selected SQL statements into the editor.