Re: Linked server only allow access to one database

From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
Date: Tue, 05 Feb 2008 14:33:33 -0800

jbyrd (jayloub@xxxxxxxxxxx) writes:

Is it easy to add a linked server and only allow the linked server to
use a single view in one database?

You can set up with sp_addlinkedsrvlogin how to log in at the remote
server. In this case, you would log in with a user that has access to
this single database with the view.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

References:
- Linked server only allow access to one database
  - From: jbyrd

Prev by Date: Linked server only allow access to one database
Next by Date: Re: Permissions Across Databases
Previous by thread: Linked server only allow access to one database
Next by thread: Re: Permissions Across Databases
Index(es):
- Date
- Thread

Relevant Pages

Re: How to Replicate an SQL Server 2000 Database
... actual server name) enterprise manager should associate the database with the ... Looking for a SQL Server replication book? ...
(microsoft.public.sqlserver.replication)
RE: WSS install locked into MSDE DB - Can not install for SQL Serv
... For the MASTER database ... Althought we change the Configuration Application pool several times ... interface BUT they appear to be MSDE databases and not SQL Server databases. ...
(microsoft.public.sharepoint.windowsservices)
Re: SQL 2005 Best Practice vs SQL 2000: Application Files Separate from data (and log) files
... I have had quite a number of clients that used a SAN for a database server and suffered significant performance problems because their underlying SAN infrastructure was a huge stripe across many drives. ... By application files I mean the binn folder which contains the sql server executable among other things. ...
(microsoft.public.sqlserver.setup)
Re: FCB::RemoveAlternateStreams: Operating system error (null)
... Thanks for all your help Ekrem, even if your sugestion does not solve the ... in this edition of SQL Server the ... database so it's opened again and you get this error somehow. ...
(microsoft.public.sqlserver.setup)
RE: SBS 2003 Unable to connect to database STS_Config
... Check the database connection information and make sure that the database ... Uninstall SQL Server; ... Reinstall Monitoring and Sharepoint and make sure they work; ...
(microsoft.public.windows.server.sbs)