Creating Database Users with schema : USER « User Role « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. User Role
  3. USER
USE YourDatabaseName
GO
CREATE USER Joe
FOR LOGIN [YourID\TestUser]
WITH DEFAULT_SCHEMA = HumanResources








28.11.USER
28.11.1.Creating Database Users with schema
28.11.2.select USER
28.11.3.Change the default schema for user Fred
28.11.4.Create a proxy user
28.11.5.Create a user and a table, and make the user own the table
28.11.6.Modifying a Database User for the schema
28.11.7.Modifying a Database User for name
28.11.8.Removing a Database User from the Database