How to Assign Default Schema to AD Group in SQL Server - SQL Server DBA Tutorial

This video shows step by step process of assigning default schema to SQL Server Group login. It explains using how to assign schema to AD group Login in SQL Server 2005, 2008, 2012 and 2014. It shows how to create schema in SQL Server Database and add user permission to the newly created schema.

--Script:
--How to assign Default Schema to AD Group in SQL Server


--SQL Server 2005
--Create Schema using T-SQL or Management studio

USE [Demo]
GO
CREATE SCHEMA [Myschema]
GO
--Create Login First and then go in Schema to Set Group default schema
USE [master]
GO
CREATE LOGIN [TECHBROTHERS\SQLDBReader] FROM WINDOWS WITH DEFAULT_DATABASE=[master]
GO
Use [Demo]
ALTER AUTHORIZATION ON SCHEMA::[Myschema] TO [TECHBROTHERS\SQLDBReader]

How to Assign Default Schema to AG Group in SQL Server - MS SQL Server DBA Tutorial