Linked server access

From: greg (gregory.goualard@airliquide.com)
Date: 10/29/02 

From: "greg" <gregory.goualard@airliquide.com>
Date: Tue, 29 Oct 2002 00:13:35 -0800

I did it. I created an account on the server B and set the
linked server in order to do the mapping between this
account and the external users account off the server A.

The problem is, when a trigger of database A fires, it is
executed with the external users rights so that I have to
give them the rights on the database B tables too.

>-----Original Message-----
>How is your ,linked server authoentication set up?
>
>If you want to be selective about the use of it then
>prevent users from accessing db B by not creating logins
>for them, and change the authoentication on the linked
>server to use the user's own security context rather than
>say 'sa'
>
>
>>-----Original Message-----
>>Hi,
>>
>>I wonder if it's possible to restrict the access to a
>>linked server object like I could do with a table
>(select,
>>update, delete,...).
>>
>>My application stands on two databases A and B on two
>>different servers.
>>External users can insert data into the database A. Then
>>triggers sends data to the database B via the linked
>>server. Naturally, I don't want external users accessing
>>directly to the database B. Yet, it's possible if they
>>execute requests through the linked server...
>>
>>Is it possible to avoid this security hole ?
>>.
>>
>.
>

Relevant Pages

  • Re: Setting up Linked server to MsAccess
    ... "All users should typically be accessing the Access database ... with the user Admin and no password. ... This will set the security so anyone using the linked server ...
    (microsoft.public.sqlserver.security)
  • Re: Setting up Linked server to MsAccess
    ... I'm running SQL Server\Express in "Windows Authenication Mode" (Do I have to ... they are accessing my MS Access linked server? ... Containing folders with MSAccess Database X.mdb ... SQl Express has linked server X mapped via UNC to Database X.mdb ...
    (microsoft.public.sqlserver.security)
  • Re: Setting up Linked server to MsAccess
    ... This will set the security so anyone using the linked server ... At the database level I have added my Server login ...
    (microsoft.public.sqlserver.security)
  • Linked server from SQL Server to Access db on network share?
    ... I have an Access database that exists on a network share ... that I'm trying to link to as a linked server from SQL ...
    (microsoft.public.sqlserver.security)
  • Re: Linked server from SQL Server to Access db on network share?
    ... > I have an Access database that exists on a network share ... > that I'm trying to link to as a linked server from SQL ...
    (microsoft.public.sqlserver.security)