AZR-SQL101

-- --  Database Credential -- -- Drop db credential IF EXISTS(SELECT * FROM sys.database_credentials WHERE name = '<<CrendentialName>>') DROP DATABASE SCOPED CREDENTIAL <<CrendentialName>> ;  GO -- Create db credential CREATE DATABASE SCOPED CREDENTIAL <<CrendentialName>> WITH IDENTITY = '<<UserName>>', SECRET = '<<UserStrongPassword>>';  GO Till Next Time

-- Remove existing user DROP USER IF EXISTS [<<UserName>>] GO -- Create new user CREATE USER USR_CROSS_DBMS WITH PASSWORD = '<<Really Strong Password>>',   DEFAULT_SCHEMA=[dbo] GO -- Add user to the database owner role EXEC sp_addrolemember N'db_owner', N'<<UserName>>' GO Till Next Time