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

2 comments:

  1. Thank you so much ,all your video is very help full.

    ReplyDelete
  2. TODAY I GOT MY DESIRED XMAS LOAN AMOUNT $520,000.00 FROM A RELIABLE AND TRUSTED LOAN COMPANY. IF YOU NEED A LOAN NOW EMAIL CONTACT drbenjaminfinance@gmail.com

    Hello, I'm here to testify of how i got my loan from BENJAMIN LOAN FINANCE(drbenjaminfinance@gmail.com) I don't know if you are in need of an urgent loan to pay bills, start business or build a house, they offer all kinds of loan. So feel free to contact Dr. Benjamin Owen he holds all of the information about how to obtain money quickly and painlessly without cost/stress via Email: drbenjaminfinance@gmail.com

    Consider all your financial problems tackled and solved ASAP. Share this to help a soul right now THANKS.

    ReplyDelete