Saturday, March 04, 2017

azure sql db create login and user

CREATE LOGIN my20170403  WITH PASSWORD='pwd1'
alter login my20170403  ENABLE
alter login my20170403  WITH PASSWORD='mypwd'
alter login my20170403 WITH DEFAULT_DATABASE = mydb

create user my20170403 for login my20170403 with default_schema = [dbo]

to connect with sql management studio
also needs user in master database - because deafult database not there

No comments: