TABLE 1: SQL Server Permissions You Can Set in Access Projects
Permission Name Permission Description Database Objects That Permission Applies To
SELECT See a table in the Database window; perform a SELECT statement Tables and Views
INSERT Add a new record to a data source in a datasheet or a form; Tables and Views
perform an INSERT statement
UPDATE Edit an existing column value for a data source in a datasheet Tables and Views
or a form; perform an UPDATE statement
DELETE Delete a row from a data source in a datasheet or a form; Tables and Views
perform a DELETE statement
DRI Set a foreign-key reference in one table to a primary key or Tables
another unique key in a second table
EXECUTE Run a stored procedure from the Database window; perform Stored Procedures
an EXECUTE statement against a stored procedure