SqlServer

From eBabel wiki
Jump to: navigation, search

Create a user

To create a user DbUsername for the database Db:

USE master;
CREATE LOGIN [DbUsername] WITH PASSWORD=N'YourPassword', DEFAULT_DATABASE=Db, CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF;
USE Db;
CREATE USER [DbUsername] FOR LOGIN [DbUsername] WITH DEFAULT_SCHEMA=[dbo];

The user Studio Manager to map the created user as dbowner.