• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 9. SQL Server Security > Administering Statement Permissions

Administering Statement Permissions

Statement-level permissions allow you to determine what rights a user or role has to a specified statement. To assign statement-level permissions:

1.
Right click the database to which you want to assign statement-level permissions and select Properties. Click to select the Permissions tab (see Figure 9.23).

Figure 9.23. The Permissions tab of the Properties window allows you to assign the appropriate statement permissions to each user or role.


2.
Click to assign the appropriate statement permissions to each user and/or role.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint