Sql2008加解密

 

 

 

 

 

Declare @p varbinary(MAX)

Create Procedure [HuntFox].[EncryptionProcedure ]
with encryption  
AS  
select N'你看不到'
go  

Functions (except inline table-valued functions), Stored Procedures, and DML Triggers
{ EXEC | EXECUTE } AS { CALLER | SELF | OWNER | 'user_name' }

DDL Triggers with Database Scope
{ EXEC | EXECUTE } AS { CALLER | SELF | 'user_name' }

DDL Triggers with Server Scope and logon triggers
{ EXEC | EXECUTE } AS { CALLER | SELF | 'login_name' }

Queues
{ EXEC | EXECUTE } AS { SELF | OWNER | 'user_name' }

 

 

Create Procedure [HuntFox].[EncryptionProcedure1 ]
with
EXECUTE AS 'NT AUTHORITY\SYSTEM',encryption
AS  
select N'你看不到'
go 

 DML 触发器 、DDL 触发器 和 登录触发器 

DML 事件包括在指定表或视图中修改数据的 INSERT 语句、UPDATE 语句或 DELETE 语句

DDL 触发器是一种特殊的触发器，它在响应数据定义语言 (DDL) 语句时触发。它们可以用于在数据库中执行管理任务，例如，审核以及规范数据库操作。

 CREATE TRIGGER 索引DDL触发
ON DATABASE 
FOR

CREATE_INDEX, ALTER_INDEX, DROP_INDEX 
AS

CREATE TRIGGER 安全性DDL触发 
ON ALL SERVER 
FOR

CREATE_LOGIN

Create TRIGGER 登录触发 
ON ALL SERVER 
WITH EXECUTE AS 'fox' 
FOR

LOGON 

ALTER TRIGGER [Finance].[CommoditySaleDetailTrigger]
   ON  [Finance].[CommoditySaleDetails]
   AFTER

 INSERT

AS

SELECT @p=EncryptByPassPhrase(   
N'MyPassword',   
N'加密内容') 
select @p as 密文,CAST(DecryptByPassPhrase(   
N'MyPassword',   
@p) as Nvarchar(max))  as 明文 


--profiler
Declare @p varbinary(MAX)
--*ASSIGN------------------------
-----------------
---------
--*SELECT WITHOUT QUERY---------------------
-----------------
-----------------------------