ADP Security Settings

J

Jeff

I have an ADP file pointing to a SQL Server 2005 DB. I'm looking to secure
the data in the tables. Currently everyone is setup as an owner through the
SQL Server Manager. All of the data in the application is pulled/connected
using stored procedures.
- Some directly through the form's data source in the properties
interface
- Other are dynamically constructed using VBA
- All use "dbo." prefix (a problem encountered earlier)
When I just grant the users read/write/execute privileges on the DB, the ADP
can no longer find the stored procedures. What privileges must I grant the
user to get around this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL Server 2000/adp problem 1
Adodb connection to different SQL SERVER DB 3
SQL Schema permissions AD group not recognized by Access 2007 ADP 1
Server error 262 create data base permission denied in database ma 0
Access 2000 ADP and SQL Server 2005 2
Future of ADP - new article 12
Security Hole in ADO Connection from ADP to SQL Server 19
Stored procedure as row source for a combo box 4

Top