\SQL\Aeries SQL
  Back
 Count of SBG in All Databases.sql
 Create Role SQL.sql
 Create User Statements.sql
 Merge BCY, BST, BCU Between Years.sql
 Reset All Users Passwords.sql
 Roles Assigned to a Role.sql
Create User Statements.sql 
-- User Creation Scripts

-- Create Login
CREATE LOGIN  WITH PASSWORD='', CHECK_EXPIRATION = OFF, CHECK_POLICY = OFF;

-- Set the Schema
ALTER USER  WITH DEFAULT_SCHEMA = dbo;

-- Create the User for the database
CREATE USER  FOR LOGIN  WITH DEFAULT_SCHEMA = dbo;

-- Add a user to a role
EXEC sp_addrolemember '', ''