Change setup to include permissions explicitly

DRediske · web-flow · commit fe3fd6320a0f · 2016-08-03T16:01:37.000-07:00
diff --git a/samples/features/security/contoso-clinic/setup/Create-Application-Login.sql b/samples/features/security/contoso-clinic/setup/Create-Application-Login.sql
@@ -1,3 +1,9 @@
 -- Create a non-sysadmin account for the application to use
-CREATE LOGIN ContosoClinicApplication WITH PASSWORD = '{Some Strong Password}'
+CREATE LOGIN [ContosoClinicApplication] WITH PASSWORD = <enter a strong password here>
+CREATE USER [ContosoClinicApplication] FOR LOGIN [ContosoClinicApplication]
+EXEC sp_addrolemember N'db_datareader', N'ContosoClinicApplication' 
+EXEC sp_addrolemember N'db_datawriter', N'ContosoClinicApplication' 
+GRANT VIEW ANY COLUMN MASTER KEY DEFINITION TO  [ContosoClinicApplication] 
+GRANT VIEW ANY COLUMN ENCRYPTION KEY  TO  [ContosoClinicApplication]
+
 
