Online Documentation for SQL Administrator for SQL Server

Setting user permissions

This section allows you to grant different permissions to the user.

This section is available only when editing an existing user.

Use the navigation bar to select a Securable type.

The Permission column contains the list of objects of the selected type; each subsequent column corresponds to the permission which can be granted on the selected object:

State (for database permissions);

Select, Insert, Update, Delete, References, Alter, Control, Take ownership, View definition, View change tracking (for tables);

Select, Insert, Update, Delete, References, Alter, Control, Take ownership, View definition (for views, inline table-valued functions);

Execute, Alter, Control, Take ownership, View definition (for procedures, extended procedures);

Select, References, Alter, Control, Take ownership, View definition (for table-valued functions);

Execute, References, Alter, Control, Take ownership, View definition (for scalar functions, aggregate functions, XML schema collections);

Select, Insert, Update, Delete, Execute, Control, Take ownership, View definition (for synonyms);

Execute, References, Control, Take ownership, View definition (for data types);

Select, Insert, Update, Delete, Execute, References, Alter, Control, Take ownership, View definition (for schemas);

Alter, Control, Take ownership, View definition (for roles, routes, remote service bindings);

Alter, Control, Impersonate, View definition (for users);

Alter, Control, View definition (for application roles);

References, Alter, Control, Take ownership, View definition (for assemblies, full-text catalogs, certificates, asymmetric keys, symmetric keys, message types, contracts);

Select, Receive, References, Alter, Control, Take ownership, View definition (for queues);

Send, Alter, Control, Take ownership, View definition (for services).

To learn more about setting permissions for a user see the Database Permissions topic.