怎么才能限制SQL Server只能讓指定的機(jī)器連接
更新時(shí)間：2007年03月06日 00:00:00 作者：
正在看的ORACLE教程是:怎么才能限制SQL Server只能讓指定的機(jī)器連接。Q. How can I restrict access to my SQL Server so that it only allows certain machines to connect?
(v1.0 19.10.1998)
怎樣才能限制我的SQL Server只能讓指定的機(jī)器連接
A. SQL Server has no built-in tools/facilities to do this. It also does not have the facility to run a stored-procedure on connection that could be written/used to do this. Therefore you have the following choices :-
SQL Server沒(méi)有這樣的功能，也沒(méi)有提供在連接時(shí)執(zhí)行某一特定過(guò)程的功能。這里介紹幾種實(shí)現(xiàn)的方法
1. Put the SQL Server behind a firewall and use that to restrict access. This is the most secure and functional way to do what you want.
使用防火墻，它提供了安全和你想用的工具。
2. Write your own ODS Gateway and point the clients at that instead of the SQL Server - the ODS Gateway will then do the checking. However, there is nothing stopping clients figuring out the correct SQL client-config entries to point straight at the SQL Server. There are examples of ODS code in the SQL Programmers Toolkit - available for free download from the MS website.
寫自己的ODS網(wǎng)關(guān)代替SQL Server的客戶端 - 在ODS網(wǎng)關(guān)中檢查。不過(guò)，這并不能停止正常的客戶端連接SQL Server。在SQL Programmers Toolkit中有一個(gè)這樣的例， 可以從微軟站點(diǎn)免費(fèi)下載。
3. Write a constantly running/scheduled stored-procedure that checks the relevant column in sysprocesses (net_address), and then issues a KILL command for any processes that should not be running. Note that this only works for MAC addresses. This way allows people to connect and possibly make changes before they are spotted and killed.
寫一個(gè)存儲(chǔ)過(guò)程檢查sysprocesses中的相應(yīng)列（net_address）
<
(v1.0 19.10.1998)
怎樣才能限制我的SQL Server只能讓指定的機(jī)器連接
A. SQL Server has no built-in tools/facilities to do this. It also does not have the facility to run a stored-procedure on connection that could be written/used to do this. Therefore you have the following choices :-
SQL Server沒(méi)有這樣的功能，也沒(méi)有提供在連接時(shí)執(zhí)行某一特定過(guò)程的功能。這里介紹幾種實(shí)現(xiàn)的方法
1. Put the SQL Server behind a firewall and use that to restrict access. This is the most secure and functional way to do what you want.
使用防火墻，它提供了安全和你想用的工具。
2. Write your own ODS Gateway and point the clients at that instead of the SQL Server - the ODS Gateway will then do the checking. However, there is nothing stopping clients figuring out the correct SQL client-config entries to point straight at the SQL Server. There are examples of ODS code in the SQL Programmers Toolkit - available for free download from the MS website.
寫自己的ODS網(wǎng)關(guān)代替SQL Server的客戶端 - 在ODS網(wǎng)關(guān)中檢查。不過(guò)，這并不能停止正常的客戶端連接SQL Server。在SQL Programmers Toolkit中有一個(gè)這樣的例， 可以從微軟站點(diǎn)免費(fèi)下載。
3. Write a constantly running/scheduled stored-procedure that checks the relevant column in sysprocesses (net_address), and then issues a KILL command for any processes that should not be running. Note that this only works for MAC addresses. This way allows people to connect and possibly make changes before they are spotted and killed.
寫一個(gè)存儲(chǔ)過(guò)程檢查sysprocesses中的相應(yīng)列（net_address）
<
相關(guān)文章
這篇文章主要介紹了Oracle如何刪除表空間的語(yǔ)法及代碼的相關(guān)資料,Oracle數(shù)據(jù)庫(kù)中刪除表空間是一個(gè)關(guān)鍵操作,需要謹(jǐn)慎執(zhí)行,確保數(shù)據(jù)備份和評(píng)估業(yè)務(wù)影響,文中通過(guò)代碼介紹的非常詳細(xì),需要的朋友可以參考下2025-03-03
Oracle 批處理自動(dòng)備份bat腳本語(yǔ)句的步驟詳解
這篇文章主要介紹了Oracle 批處理自動(dòng)備份bat腳本語(yǔ)句的步驟詳解,本文給大家介紹的非常詳細(xì)，對(duì)大家的學(xué)習(xí)或工作具有一定的參考借鑒價(jià)值，需要的朋友可以參考下2021-01-01
文章介紹了如何快速解除Oracle Data Guard配置的過(guò)程,包括備份SPFILE到PFILE、調(diào)整主庫(kù)模式、修改主庫(kù)DG配置參數(shù)、刪除Standby Log以及重啟數(shù)據(jù)庫(kù)等步驟,感興趣的朋友一起看看吧2025-03-03
在繼續(xù)Oracle客戶端的安裝之前，需要分析一下Oracle客戶端與數(shù)據(jù)庫(kù)服務(wù)器之間的連接機(jī)制2012-11-11
這篇文章主要介紹了oracle管道函數(shù)的用法(一行拆為多行),非常不錯(cuò)，具有一定的參考借鑒價(jià)值，需要的朋友可以參考下2019-08-08
Oracle數(shù)據(jù)庫(kù)的安全策略...2007-03-03
基于Oracle的面向?qū)ο蠹夹g(shù)入門基礎(chǔ)簡(jiǎn)析開(kāi)發(fā)者網(wǎng)絡(luò)Oracle
基于Oracle的面向?qū)ο蠹夹g(shù)入門基礎(chǔ)簡(jiǎn)析開(kāi)發(fā)者網(wǎng)絡(luò)Oracle...2007-03-03
Centos下Oracle11gR2安裝教程與自動(dòng)化配置腳本的方法
這篇文章主要介紹了Centos下Oracle11gR2安裝教程與自動(dòng)化配置腳本的方法，文中通過(guò)示例代碼介紹的非常詳細(xì)，對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值，需要的朋友們下面隨著小編來(lái)一起學(xué)習(xí)學(xué)習(xí)吧2020-10-10
Oracle臨時(shí)表空間主要是用于數(shù)據(jù)庫(kù)較大的臨時(shí)排序用,在PGA分配的工作區(qū)空間不足以容納排序數(shù)據(jù)時(shí)使用臨時(shí)表空間,但是容易遇到oracle臨時(shí)表空間無(wú)法釋放的問(wèn)題,所以本文給大家介紹了oracle臨時(shí)表空間無(wú)法釋放的解決辦法,需要的朋友可以參考下2024-03-03
oracle數(shù)據(jù)庫(kù)導(dǎo)出和oracle導(dǎo)入數(shù)據(jù)的二種方法(oracle導(dǎo)入導(dǎo)出數(shù)據(jù))
這篇文章主要介紹了oracle導(dǎo)入導(dǎo)出數(shù)據(jù)的二種方法，利用PL/SQL Developer工具導(dǎo)出和利用cmd的操作命令導(dǎo)出的出方法，大家參考使用吧2014-01-01