项目作者: ogaudefroy

项目描述 :
Some stored procedures to enable/disable Transparent Data Encryption in SQL Server
高级语言:
项目地址: git://github.com/ogaudefroy/sp_tde.git
创建时间: 2016-11-23T21:06:05Z
项目社区:https://github.com/ogaudefroy/sp_tde

开源协议:MIT License

下载


sp_tde

Some stored procedures to enable/disable Transparent Data Encryption in SQL Server

sp_tde_create_dmk

Creates the database master key with password encryption.
Usage: exec sp_tde_create_dmk '98498aezaS'

sp_tde_drop_dmk

Drops the database master key
Usage: exec sp_tde_drop_dmk

sp_tde_create_certificate

Creates a certificate to encrypt the database
Usage: exec sp_tde_create_certificate 'SampleCertificateName' 'SampleCertificateSubject'

sp_tde_drop_certificate

Drops a certificate stored in sys.certificates
Usage: exec sp_drop_certififacte 'SampleCertificateName'

sp_tde_create_dek

Creates a database encryption key based on the specifed certificate.
Usage: exec sp_tde_create_dek 'MyDataBase'

sp_tde_drop_dek

Creates a database encryption key based on the specifed certificate.
Usage: exec sp_tde_drop_dek 'MyDataBase'

sp_tde_enable

Turns on transparent data encryption on the specified database and encrypts its content with its configured database encryption key.
Polls the Encryption process and displays percentage progress.
Usage: exec sp_tde_disable 'MyDataBase'

sp_tde_disable

Turns off transparent database encryption on the specified database and decrypts its content with its configured database encryption key.
Polls the decryption process and displays percentage progress.
Usage: exec sp_tde_disable 'MyDataBase'