Databases Reference
In-Depth Information
Figure 8.6
Security options for
links in SQL
Server.
You can see all of the SQL Server link options by right-clicking on a
linked server within the Enterprise Manager (your server -> Security ->
Linked Servers) and selecting the properties option. In the Security tab
(shown in Figure 8.6), you can choose to provide an explicit user mapping,
make connections using the current context, use a single remote username,
and so on.
8.3
Protect link usernames and passwords
Enforcing security on links is first and foremost about making sure that
access to links (and thus access to automatic logins on the remote database)
is provided only to legitimate accounts within database A. However, you
should take extra care to ensure that links do not create security holes.
Link information is maintained within the database, and you must
make sure that this information is secured within the database. As an exam-
ple, Oracle maintains link information in a table called SYS.LINK$:
Search WWH ::
Custom Search