GRANT User Read Permission Linked Server

Question

Post reply

GRANT User Read Permission Linked Server

Welsh Corgi

SSC Guru

Points: 116520
More actions
February 15, 2012 at 11:02 am

#250758

How do I grant a User read permissions to a linked server (AS400 DB2)?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323547 More actions · Answer 1

you need to create a user on the AS400 that has read only permissions.

then when you create the linked server, use that specific user for the remote login.

it is not possible to limit the permissions on the sql server side.

if the remote login has more permissions than you want to let your SQL users have, you need an additional login on the remote side of things.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

Thanks Lowell. I had created the Linked Server and used a Login on the AS400.

I just wanted to make sure that I did not forget anything before the Users tested it.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/