開發商用 WITH ENCRYPTION 加密存儲過程,導致無法查看定義。SQL Server 加密僅為**混淆**(XOR 加密),非真加密,可逆向還原。
SYSCOMMENTS.CTEXT(加密後)。WITH ENCRYPTION),其 CTEXT 為已知明文模式(如全 '-')。原文 ⊕ 假明文 ⊕ 假密文 = 原文。逐字符異或還原。WITH ENCRYPTION 關鍵字,輸出明文定義。CREATE PROCEDURE SP_Decrypt @ObjName SYSNAME
AS
BEGIN
SET NOCOUNT ON;
BEGIN TRAN;
DECLARE @M INT = (SELECT MAX(COLID) FROM SYSCOMMENTS WHERE ID = OBJECT_ID(@ObjName));
DECLARE @N INT = 1;
CREATE TABLE #Tmp (ColID INT, CText VARBINARY(8000));
INSERT #Tmp SELECT COLID, CTEXT FROM SYSCOMMENTS WHERE ID = OBJECT_ID(@ObjName);
-- 構造假加密對象
DECLARE @Fake NVARCHAR(MAX) = N'ALTER PROCEDURE ' + QUOTENAME(@ObjName) + N' WITH ENCRYPTION AS ' + REPLICATE(N'-', 4000);
EXEC(@Fake); -- 生成假密文
WHILE @N <= @M
BEGIN
DECLARE @Orig VARBINARY(8000) = (SELECT CTEXT FROM #Tmp WHERE COLID = @N);
DECLARE @FakeOrig NVARCHAR(4000) = (SELECT CTEXT FROM SYSCOMMENTS WHERE ID = OBJECT_ID(@ObjName) AND COLID = @N);
DECLARE @FakePlain NVARCHAR(4000) = CASE WHEN @N=1
THEN N'CREATE PROCEDURE ' + QUOTENAME(@ObjName) + N' WITH ENCRYPTION AS ' + REPLICATE(N'-', 4000 - LEN(N'CREATE PROCEDURE ' + QUOTENAME(@ObjName) + N' WITH ENCRYPTION AS '))
ELSE REPLICATE(N'-', 4000) END;
DECLARE @Res NVARCHAR(4000) = REPLICATE(N'A', DATALENGTH(@Orig)/2);
DECLARE @I INT = 1;
WHILE @I <= DATALENGTH(@Orig)/2
BEGIN
SET @Res = STUFF(@Res, @I, 1, NCHAR(
UNICODE(SUBSTRING(CAST(@Orig AS NVARCHAR(MAX)), @I, 1)) ^
UNICODE(SUBSTRING(@FakePlain, @I, 1)) ^
UNICODE(SUBSTRING(@FakeOrig, @I, 1))
));
SET @I += 1;
END
SET @Res = REPLACE(REPLACE(REPLACE(@Res, 'WITH ENCRYPTION', ''), 'With Encryption', ''), 'with encryption', '');
PRINT @Res; -- 輸出明文片段
SET @N += 1;
END
DROP TABLE #Tmp;
ROLLBACK TRAN; -- 回滾假對象創建
END;
EXEC SP_Decrypt 'Your_Encrypted_Proc_Name';
結果面板將打印明文定義,複製保存即可。
MODULE_PRIVACY (隱藏定義) + 權限控制,而非依賴弱加密。