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!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Stored Procedure Permission Problem

Status
Not open for further replies.
yakdogs

yakdogs

Programmer
Aug 13, 2002
40
US
I am really new to SQL.

I have built a DB with Access project front end and SQL and a backend. All stored procedures work when logged in as SA. But when I sign in as a user I get a "cant not find record source sp_XXXXXXX.

I did go into securities under SQL Database Access. I did click all the EXEC on the SP(which I assume is an EXECUTE) for the group. I still get this error.

I assume that I have not released all permissions yet. Oh, I have not set securities on the Access side of the DB yet.

Can someone help me?
 
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question
Field change as caused issues to store procedure
Replies
19
Views
736
Andrzejek
Andrzejek
Auguy
  • Locked
  • Question
Passing TVP instead of Individual Parameters to Procedure
Replies
0
Views
227
Auguy
Auguy
SamBones
  • Locked
  • Question
Problem with ON UPDATE CURRENT_TIMESTAMP
Replies
0
Views
348
SamBones
SamBones
ghiehotamares
  • Locked
  • Question
How to call stored procedure to display records in fron-end data entry
Replies
1
Views
260
fredericofonseca
fredericofonseca
BeatriceC
  • Locked
  • Question
SQL Linked server StoredProcefure job creates temp files
Replies
1
Views
296
pjw001
pjw001

Part and Inventory Search

Sponsor

Back
Top