Open Query

I have looked at a lot of diffent ideas, but does anyone know how to lock down an open query in SQL. An example of this would be, lets say I have a linked server  that has open query. How could I make it so, that only certain users could access said query.

Thanks!!
LVL 5
Jojo1771Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

muzzy2003Commented:
Can't you just do that by appropriately mapping your local user IDs to remote ones when you set up the linked server?
0
Duane LawrenceCommented:
Hit the F1 key and bring up books online, that is where I found this.

deny all
on stored_proc_name
to userid_name

grant exec
on stored_proc_name
to userid_name



See Also

Granting Permissions
DENY
REVOKE
sp_addgroup
sp_addlogin
sp_adduser
sp_changegroup
sp_changedbowner
sp_dropgroup
sp_dropuser
sp_helpgroup
sp_helprotect
sp_helpuser
0
arbertCommented:
Agree with Muzzy2003, take a look at using a linked server.  Not only can you map logins, but you don't have to hardcode a user/password as you do with openquery (of course, if you're using openquery to obtain a true passthru query, then a  linked server may not be an option)....Granting and revoking permissions would be an option if you encapsulate your openquery in a proc..
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jojo1771Author Commented:
Not what I was looking for, but your input is appreciated.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.