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

Creating a certificate and an asymmetric key

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>

Creating a certificate in the master database

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