How do I create a new user in a SQL Azure database - Express Video Tutorial

preview_player
Показать описание
This video tutorial will demonstrate how to create a new user in SQL Azure Database.

Code used in this Express Tutorial:
Script #1
USE [master]
CREATE LOGIN TestUser WITH password='xxx123';
CREATE USER TestUser FROM LOGIN TestUser;

Script #2 (destination DB)
CREATE USER TestUser FROM LOGIN TestUser;

EXEC sp_addrolemember N'db_owner', N'TestUser'
GO

Code Download:

About me:

My Photography:
Рекомендации по теме
Комментарии
Автор

When I right click on System Databases\master\Security\New\User, the script is entirely different. Why is your's so different then what I see ?

wavevntrdt
Автор

Is there any option to manage user provisioning through the portal?

vjj
welcome to shbcf.ru