Mega Code Archive

 

Categories / MSSQL Tutorial / User Role

 

Creating Database Users with schema

USE YourDatabaseName GO CREATE USER Joe FOR LOGIN [YourID\TestUser] WITH DEFAULT_SCHEMA = HumanResources