Physical Modeling › SQL Server Physical Property Editors › SQL Server Database Objects › Define SQL Server Permissions

Define SQL Server Permissions

Use the SQL Server Permission Editor to define permissions for a database and to define server level permissions in a SQL Server 2005/2008 physical model.

To define SQL Server permissions

1. Click Permissions on the Database menu.

   The SQL Server Permission Editor opens.

2. Select the permission in the Navigation Grid that you want to define and work with the following options:

   Note: Click New on the toolbar to create a new permission.

   • Name

     Displays the permission name. You can change the permission name in this field.

   • Type

     Specifies the permission type. Select the option from the drop-down list.

   • Cascade

     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.

   • With Grant

     Specifies if the user can grant this permission to other users or not.

   • Grant as Principal

     Specifies the principal used to acquire the permissions. Select a principal from the drop-down list.

3. Click the General tab and work with the following options:
   • Permissions to Grant

     Specifies the permissions that are granted to the selected permission. Select or clear check boxes for specific permissions, or select the All Permissions check box to grant all permissions to the permission.

   • Principals to Grant

     Specifies the principals that are granted to the selected permission. Select or clear check boxes for specific principals.

     Note: Click an icon to open one of the security editors (User ID , Application Role , or Database Role ) to further define a principal.

   • Logins to Grant

     Specifies the logins that are granted to the selected permission.

     Note: Click the Login Editor icon to open the SQL Server Login Editor to further define a login.

4. (Optional) Click the Comment tab and enter any comments that you want to associate with the permission.
5. (Optional) Click the UDP tab to work with user-defined properties for the permission.
6. Click Close.

   The permission is defined and the SQL Server Permission Editor closes.