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