filmov
tv
T-SQL: column-level encryption
Показать описание
--step 1
USE TESTDB ;
CREATE MASTER KEY ENCRYPTION BY
PASSWORD = '123Alex!@#$789';
--DROP MASTER KEY
--step 2
CREATE TABLE TABLE3
(ID int,
PERSONNAME nvarchar(200),
AGE int,
HOBBY nvarchar(200),
SALARY varbinary(128))
--step 3
CREATE CERTIFICATE MyCertificate1
WITH SUBJECT = 'Secret info - Salary';
GO
--drop CERTIFICATE MyCertificate1
CREATE SYMMETRIC KEY SSN_Key_01
WITH ALGORITHM = AES_256
ENCRYPTION BY CERTIFICATE MyCertificate1;
GO
--drop SYMMETRIC KEY SSN_Key_01
--step 4
OPEN SYMMETRIC KEY SSN_Key_01
DECRYPTION BY CERTIFICATE MyCertificate1;
INSERT INTO TABLE3 VALUES
(1,'Alex',40,'skateboarding', EncryptByKey(Key_GUID('SSN_Key_01'), '1000')),
(2,'John',32,'wrestling',EncryptByKey(Key_GUID('SSN_Key_01'), '1500')),
(3,'Asti',25,'jogging',EncryptByKey(Key_GUID('SSN_Key_01'), '24560')),
(4,'Jay',53,'football',EncryptByKey(Key_GUID('SSN_Key_01'), '502')),
(5,'Selena',40,'yoga',EncryptByKey(Key_GUID('SSN_Key_01'), '2500'))
--truncate table TABLE3
--DROP TABLE TABLE3
--step 5
OPEN SYMMETRIC KEY SSN_Key_01
DECRYPTION BY CERTIFICATE MyCertificate1;
SELECT
*,
CONVERT(varchar, DecryptByKey(SALARY)) AS [Decrypted Salary]
FROM TABLE3
CLOSE SYMMETRIC KEY SSN_Key_01
USE TESTDB ;
CREATE MASTER KEY ENCRYPTION BY
PASSWORD = '123Alex!@#$789';
--DROP MASTER KEY
--step 2
CREATE TABLE TABLE3
(ID int,
PERSONNAME nvarchar(200),
AGE int,
HOBBY nvarchar(200),
SALARY varbinary(128))
--step 3
CREATE CERTIFICATE MyCertificate1
WITH SUBJECT = 'Secret info - Salary';
GO
--drop CERTIFICATE MyCertificate1
CREATE SYMMETRIC KEY SSN_Key_01
WITH ALGORITHM = AES_256
ENCRYPTION BY CERTIFICATE MyCertificate1;
GO
--drop SYMMETRIC KEY SSN_Key_01
--step 4
OPEN SYMMETRIC KEY SSN_Key_01
DECRYPTION BY CERTIFICATE MyCertificate1;
INSERT INTO TABLE3 VALUES
(1,'Alex',40,'skateboarding', EncryptByKey(Key_GUID('SSN_Key_01'), '1000')),
(2,'John',32,'wrestling',EncryptByKey(Key_GUID('SSN_Key_01'), '1500')),
(3,'Asti',25,'jogging',EncryptByKey(Key_GUID('SSN_Key_01'), '24560')),
(4,'Jay',53,'football',EncryptByKey(Key_GUID('SSN_Key_01'), '502')),
(5,'Selena',40,'yoga',EncryptByKey(Key_GUID('SSN_Key_01'), '2500'))
--truncate table TABLE3
--DROP TABLE TABLE3
--step 5
OPEN SYMMETRIC KEY SSN_Key_01
DECRYPTION BY CERTIFICATE MyCertificate1;
SELECT
*,
CONVERT(varchar, DecryptByKey(SALARY)) AS [Decrypted Salary]
FROM TABLE3
CLOSE SYMMETRIC KEY SSN_Key_01
0:09:03
T-SQL: column-level encryption
0:11:48
04 Column Level Encryption
0:02:08
Databases: Column Level Encryption in SQL Server 2016
0:10:10
Enabling encryption in a Microsoft SQL database
0:14:54
SQL Server Always On Series: Mastering SQL Security: Column Level Encryption in Always On Failovers
0:01:40
C# : Entity Framework with Sql Server Column Level Encryption
0:27:55
Protect your sensitive data using different encryption technique provided by SQL Server
0:14:29
Encryption in SQL Server | Always encrypted 2016 Demo
0:01:39
SQL Server Column Encryption - Step-by-Step Guide | VirtualTechBytes
0:10:54
DATA ENCRYPTION AND DECRYPTION in Microsoft SQL server @JSDVlogs
0:11:03
SQL Server Cell level Encryption
0:02:15
'Encryption-at-Rest' Is Crap
0:08:05
SQL Server Encryption
0:02:19
Databases: Combining Always Encrypted AND Column level encryption in SQL Server 2016
0:08:37
How to encrypt and decrypt column values in a SQL Server database | Configuration and C# Example
0:05:51
T-SQL: Hiding SQL code in view, SP or functions (WITH ENCRYPTION)
0:25:50
Database Encryption and Column Encryption in SQL server
0:04:29
Data Encryption Demo using Symmetric Key (Update the Column in a Table).
0:04:31
Symmetric Encryption Demo
0:05:27
Symmetric Encryption Overview and Demo ,SQL Security
0:41:36
Always Encrypted for Beginners
0:21:37
Encrypt Database with Transparent Data Encryption (TDE) in SQL Server 2012 [HD]
0:02:20
Dba: SQL Server Database Encryption (Column Level)
0:12:07
Oracle 12c | Transparent Data Encryption | Column Level | Tablespace Level Encryption | Overview!
Комментарии