• Article

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.

Options

  • 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.