#9786: Include default schema for Create Login UI

tariqrahiman reported 2013-08-15T22:21:36Z · last modified 2014-06-30T13:29:38Z

Include default schema for Create Login UI

Dev	ivangron
QA	SachinPrakash

Priority	Low
Complexity	Unknown

Component	App - Visual Editing
Version	15.0

Research on including default schema for Create Login UI for SQL Server

Look under Security-> Logins -> Create New Login UI

1.) We need to figure out what happens when a default schema is assigned to a login ? Currently even though I was able to create a default schema, in the Query Analyzer window, I find the default schema to be dbo. Need to find out if this is hard coded ?

2.) From Customer:

When creating a database login in SQL Server there is no a place to specify a default schema as in Microsoft SQL Server Mgmnt Studio. After creating the login and user it becomes a manual process to create the default schema.

For Create Login, below is the script that gets generated when a default schema is created on a selected database. I selected a default schema ivan for database Northwind. Management Studio created a new user and then altered the newly created user with the default schema.

USE [master]

CREATE LOGIN [jjpizzle] WITH PASSWORD=N'jjpizzle', DEFAULT_DATABASE=[NORTHWIND], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF

USE [NORTHWIND]

CREATE USER [jjpizzle] FOR LOGIN [jjpizzle]

USE [NORTHWIND]

ALTER USER [jjpizzle] WITH DEFAULT_SCHEMA=[ivan]