?? Security ??

[sparkbyte]

I have an Access ADP that I have created. When logged in as myself everything runs fine. (SQL Server sysadmn)

I have a user with dbreader/dbwriter privs user the Access ADP the main data entry for populates without any problems but any of the lookups that use stored procedures or functions fail.

What do I need to change to grant permisions propperly??

THANKS!!!!!!!!!!!

Thanks

John Fuhrman

 

[sparkbyte]

Found the answer finaly.

/* CREATE A NEW ROLE */
CREATE ROLE db_executor

/* GRANT EXECUTE TO THE ROLE */
GRANT EXECUTE TO db_executor



Thanks

John Fuhrman