SQL Server/T-SQL Tutorial/User Role/CREATE CERTIFICATE

Creating a certificate and an asymmetric key

   <source lang="sql">

7> CREATE CERTIFICATE MyCert 8> WITH Subject = "My Person Cert" 9> GO Msg 15247, Level 16, State 1, Server J\SQLEXPRESS, Line 7 User does not have permission to perform this action. 1> 2> CREATE ASYMMETRIC KEY AsymKeyPerson 3> WITH Algorithm = RSA_1024 4> GO Msg 15247, Level 16, State 1, Server J\SQLEXPRESS, Line 2 User does not have permission to perform this action. 1> 2></source>

Creating a certificate in the master database

   <source lang="sql">

5> 6> CREATE CERTIFICATE D_Certificate 7> ENCRYPTION BY PASSWORD = "stpLE@sE!" 8> WITH SUBJECT = "Certificate for D" 9> GO</source>