Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

User or Role Properties (Securables Page)

Use this page to set permissions on database securables for this user, database role or application role. Click Add to add database securables to the Securables grid. Then select a securable in the grid and set the appropriate permissions in the Explicit permissions grid.

This page only shows permissions that are explicitly granted or denied to this user or role. The principal may inherit additional permissions through membership in a group or role. Permissions inherited from a group or role are not listed in the grid. The sum of all of the explicit and implicit permissions of the principal constitutes its effective permissions.

User Name or Role name

The name of the user or role whose permissions are described on this page.

Securables

Lists the securables on which specific permissions have been granted or denied to this principal.

Schema

The schema that owns the object.

Name

The name of the securable.

Type

The type of the securable.

Effective Permissions

Opens the Effective Permissions dialog box to show the result of combining explicit permissions with permissions inherited from groups and roles.

Add

Add an object to the Securables grid.

Remove

Remove a securable from the Securables grid.

Explicit permissions for <the selected securable>

Lists the permissions that can be granted or denied on the selected securable.

Grant

Check to grant this permission to the user or role. Uncheck to revoke this permission.

With Grant

Reflects the state of the WITH GRANT option for the listed permission. This box is read-only. To apply this permission use the GRANT (Transact-SQL) statement.

Deny

Check to deny this permission to the user or role. Uncheck to revoke this permission.

Community Additions

ADD
Show:
© 2015 Microsoft