Securing database-to-database communications - Implementing Database Security and Auditing - page 238

Figure 8.3

Adding a link
using the Oracle 9i
Net Manager.

Linked Servers entity. You will see all linked servers, as shown in Figure 8.4.
You can then right-click on the Linked Servers icon and add a new link, as
shown in Figure 8.5. Notice the large number of targets that can form the
server for the link, including various OLE DB providers.
If all of this openness makes you uneasy, you can easily disable ad hoc que-
ries made using OLEDB in SQL Server; simply add the registry key Disal-

with a value of 1 in lowAdhocAccess HKEY_LOCAL_MACHINE\Software\

Microsoft\Microsoft SQL Server\Providers (or HKEY_LOCAL_MACHINE\

Software\Microsoft\Microsoft SQL Server\[instanceName]\Providers

if you are running named instances).

Figure 8.4

Linked servers in
SQL Server
Enterprise
Manager.