Friday, November 3, 2017

Creating a user in SSMS

Example 1

CREATE DATABASE SAMPLE;
CREATE LOGIN GUEST
WITH PASSWORD= '123#$@AeioU';
USE SAMPLE;
GO
CREATE USER Angela FOR LOGIN GUEST;
GO

Example 2

CREATE DATABASE SAMPLE;
CREATE LOGIN GUEST
WITH PASSWORD= '123#$@AeioU';
USE SAMPLE;
GO
CREATE USER Ammu FOR LOGIN GUEST WITH DEFAULT_SCHEMA=Student;
GO



No comments:

Post a Comment

GEN AI

  Stay Tuned....