
USE pubs
GO

CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'StrongPW#'

CREATE LOGIN certuser WITH PASSWORD = 'StrongPW1'
CREATE USER certuser FOR LOGIN certuser
GO

CREATE CERTIFICATE mycert 
 AUTHORIZATION certuser WITH SUBJECT = 'Cert for certuser' 
