Alison Balter's Mastering Access 2002 Enterprise Development

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