Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

permissions to run stored proc

Status
Not open for further replies.

Waynest

Programmer
Joined
Jun 22, 2000
Messages
321
Location
GB
What security settings does a user need to be able to execute a stored proceedure (from an Access 2000 .adp)? I have datareader & datawriter ticked currently & this isnt sufficient.

Thanks
Wayne
 

You must GRANT execute permission on the stored procedure to the user or a database role that the user is member of. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top