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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

stored proc security accross servers

Status
Not open for further replies.
mflancour

mflancour

MIS
Apr 23, 2002
379
US
i have a stored proc that queries tables from several databases on different servers. Must I give read access to every table that this proc queries? is there no way to simply give execute to the proc and they can run it?
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

MacroAlan
  • Locked
  • Question
Insert results of huge query into my table with Stored Proc
Replies
1
Views
60
Olaf Doschke
Olaf Doschke
grnzbra
  • Locked
  • Question
Syntax Problem between Servers
Replies
2
Views
71
grnzbra
grnzbra
BeatriceC
  • Locked
  • Question
SQL Linked server StoredProcefure job creates temp files
Replies
1
Views
96
pjw001
pjw001
ghiehotamares
  • Locked
  • Question
How to call stored procedure to display records in fron-end data entry
Replies
1
Views
81
fredericofonseca
fredericofonseca
Cpreston
  • Locked
  • Question
Field change as caused issues to store procedure
Replies
19
Views
192
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top