AZR-SQL101 Create User

-- 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

Reacties

Een reactie posten

Populaire posts van deze blog

AZR-SQL101 Date Language format in view

select format(GETDATE(),'dddd - dd - MMMM - yyyy','nl-NL') --> dinsdag - 11 - september - 2018 select format(GETDATE(),'ddd - dd - MMM - yyyy','nl-NL') --> di - 11 - sep - 2018 select format(GETDATE(),'dddd - dd - MMMM - yyyy','de-DE') --> Dienstag - 11 - September - 2018 select format(GETDATE(),'ddd - dd - MMM - yyyy','de-DE') --> Di - 11 - Sep - 2018 select format(GETDATE(),'dddd - dd - MMMM - yyyy','en-US') --> Tuesday - 11 - September - 2018 select format(GETDATE(),'ddd - dd - MMM - yyyy','en-US') --> Tue - 11 - Sep - 2018 Till Next Time
Meer lezen

AZR-SQL101 Linkend server from regular MS-SQL server to AZURE

USE [master] GO EXEC master.dbo.sp_addlinkedserver @server = N'<<Friendly Name>>' , @srvproduct=N'' , @provider=N'sqlncli' , @datasrc=N'<<AzureSqlServerName>>.DATABASE.WINDOWS.NET' , @catalog=N'<<databasename>>' EXEC master.dbo.sp_addlinkedsrvlogin   @rmtsrvname=N'AZR_RSZK_STG' , @useself=N'False' , @locallogin=NULL , @rmtuser=N'<<LocalAccount>>' , @rmtpassword='<<VeryStrongPassword>>' Till Next Time
Meer lezen

AZR-SQL101 Create Credential

-- --  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
Meer lezen