狠狠色丁香婷婷综合尤物/久久精品综合一区二区三区/中国有色金属学报/国产日韩欧美在线观看 - 国产一区二区三区四区五区tv

USE master;GO
-- 創(chuàng)建主密鑰CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'StrongMasterKeyPassword!23';
-- 創(chuàng)建證書CREATE CERTIFICATE MyServerCert WITH SUBJECT = 'My DEK Certificate';
-- 使用證書保護數(shù)據(jù)庫加密密鑰USE YourDatabase;GOCREATE DATABASE ENCRYPTION KEYWITH ALGORITHM = AES_256ENCRYPTION BY SERVER CERTIFICATE MyServerCert;
-- 開啟透明數(shù)據(jù)加密ALTER DATABASE YourDatabaseSET ENCRYPTION ON;GO

USE YourDatabase;GO
-- 創(chuàng)建列主鍵CREATE COLUMN MASTER KEY MyColumnMasterKeyWITH(    KEY_STORE_PROVIDER_NAME = 'MSSQL_CERTIFICATE_STORE',    KEY_PATH = 'CurrentUser/My/UniqueKeyIdentifier');
-- 創(chuàng)建列加密密鑰CREATE COLUMN ENCRYPTION KEY MyColumnEncryptionKeyWITH VALUES(    COLUMN_MASTER_KEY = MyColumnMasterKey,    ALGORITHM = 'RSA_OAEP',    ENCRYPTED_VALUE = 0x0123456789ABCDEF0123456789ABCDEF);
-- 加密列ALTER TABLE EmployeesADD EncryptedSSN varbinary(256);GO
-- 更新表以包含加密數(shù)據(jù)OPEN SYMMETRIC KEY MySymmetricKeyDECRYPTION BY CERTIFICATE MyServerCert;
UPDATE EmployeesSET EncryptedSSN = EncryptByKey(Key_GUID('MySymmetricKey'), SSN);GO

USE YourDatabase;GO
-- 為SSN列添加屏蔽規(guī)則ALTER TABLE EmployeesALTER COLUMN SSN ADD MASKED WITH (FUNCTION = 'partial(1,"XXX-XX-",4)');GO
審計SQL Server提供了一種強大的審計功能，可以記錄對敏感數(shù)據(jù)的訪問和更改。示例腳本：設(shè)置數(shù)據(jù)庫審計USE master;GO
-- 創(chuàng)建服務(wù)器審計CREATE SERVER AUDIT MyServerAuditTO FILE ( FILEPATH = 'C:\SQLAudits\' )WITH (ON_FAILURE = CONTINUE);
-- 啟動服務(wù)器審計ALTER SERVER AUDIT MyServerAuditWITH (STATE = ON);
USE YourDatabase;GO
-- 創(chuàng)建數(shù)據(jù)庫審計規(guī)范CREATE DATABASE AUDIT SPECIFICATION MyDatabaseAuditFOR SERVER AUDIT MyServerAuditADD (SELECT, INSERT, UPDATE, DELETE ON OBJECT::dbo.Employees BY public);
-- 啟動數(shù)據(jù)庫審計規(guī)范ALTER DATABASE AUDIT SPECIFICATION MyDatabaseAuditWITH (STATE = ON);GO

CREATE TABLE Employees (EmployeeID INT PRIMARY KEY,Name NVARCHAR(50),Position NVARCHAR(50),Department NVARCHAR(50),SSN NVARCHAR(11));

SELECT * FROM Employees;