SQL 安全性憑證

2013-12-25

建立憑證

CREATE CERTIFICATE CeKey
   ENCRYPTION BY PASSWORD = 'CeKey12345'
   WITH SUBJECT = 'Credit Card Certificate',
   START_DATE ='2012/01/01',
   EXPIRY_DATE = '2012/06/30';

刪除憑證

DROP CERTIFICATE CeKey

查詢

SELECT * FROM sys.certificates

==================================================================================

參考來源:

http://technet.microsoft.com/zh-tw/library/ms187798.aspx

http://technet.microsoft.com/zh-tw/library/bb895327.aspx

http://technet.microsoft.com/en-us/library/ms189511.aspx

http://www.dotblogs.com.tw/jerrymow/archive/2011/01/24/20997.aspx

Jenny:
    陽光令人愉快,雨水令人振作,
    風聲令人奮起,雪花令人興奮,
    沒有所謂的壞天氣!!
    只有不同的好天氣!!

回首頁