March 5, 2009 at 6:21 pm
Hi everyone...
I have a question related to linked servers. I have set up a linked server to an AS/400 box but I just need that linked server connection to be "read only"... I mean, that tables in the AS/400 cannot be dropped, altered, updated and so on.
is it possible?
March 8, 2009 at 2:34 pm
The security would be implemented on the AS400 side. So have a chat with the AS400 admin. If it is like SQL server, they would create an ID with read-only permissions and you would define the connection for the LinkedServer using that ID.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 9, 2009 at 7:49 am
I think we'll try that, thank you very much.
March 9, 2009 at 8:35 am
My pleasure. Good luck.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply