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 studioUSE [Demo]
GOCREATESCHEMA [Myschema]
GO--Create Login First and then go in Schema to Set Group default schemaUSE [master]
GOCREATE LOGIN [TECHBROTHERS\SQLDBReader] FROM WINDOWS WITH DEFAULT_DATABASE=[master]
GOUse [Demo]
ALTERAUTHORIZATIONONSCHEMA::[Myschema] TO [TECHBROTHERS\SQLDBReader]