You can define permissions for certain SQL Server objects using the Permission tab in the object's property editor. The Permission tab lets you create, edit, or delete permissions for a selected object. For example, if you click the Permission tab in the SQL Server Assembly Editor, any permissions that you create, edit, or delete affects the selected assembly in that editor.
To define permissions for an object in a SQL Server property editor
Note: Use the toolbar on this tab to create a new permission, delete a selected permission, or open the SQL Server Permission Editor to work with permission properties.
Displays the permission name. Change the name of the permission in this field.
Specifies the permission type. Select the option from the drop-down list.
Specifies the cascade action for the permission. Indicates the permission revoked is also revoked from other principals to which it has been granted or denied by this principal.
Specifies if the user can grant this permission to another user or not.
Specifies the principal used to acquire the permissions. Select a principal from the drop-down list.
Permissions are defined for the selected object and the property editor closes.
Copyright © 2013 CA.
All rights reserved.
|
|