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

Chapter 8. Designing SQL Server Stored P... > Stored Procedures and Security

Stored Procedures and Security

Like views, stored procedures provide an excellent tool for securing your application's data. This is because you can grant rights to a stored procedure without providing any rights to the underlying table(s). Consider the following scenario. Imagine that you create an unbound Access form by which users can select various customers. You then execute stored procedures to insert, update, and delete data. In this scenario, you can grant users view rights to the Customers table. You do not need to grant them insert, update, or delete rights to the table. Instead, you grant them execute rights to the appropriate stored procedures. In this way, you can allow your users to easily create queries and reports that use the Customer data (you granted them view rights to the table). They can only insert, update, and delete data via the stored procedures that you call from your application code.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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