CREATE DATABASE MyNewDatabase;
GO
-- Step 1: Create a Login at the Server level
CREATE LOGIN MyNewLogin
WITH PASSWORD = 'YourStrongPassword123!';
GO
-- Step 2: Switch to your specific database
USE MyNewDatabase;
GO
-- Step 3: Create a Database User mapped to that Login
CREATE USER MyNewUser FOR LOGIN MyNewLogin;
GO
-- Step 4: Grant Permissions (Assign a role)
-- Option A: Give them full read/write access
ALTER ROLE db_datareader ADD MEMBER MyNewUser;
ALTER ROLE db_datawriter ADD MEMBER MyNewUser;
GO
-- Option B: Give them full admin access to this specific database instead
-- ALTER ROLE db_owner ADD MEMBER MyNewUser;
-- GO
Example:
create database CDM_DB;
GO
use CDM_DB;
CREATE USER cdmuser FOR LOGIN cdmuser;
GO
ALTER ROLE db_datareader ADD MEMBER cdmuser;
ALTER ROLE db_datawriter ADD MEMBER cdmuser;
ALTER ROLE db_ddladmin ADD MEMBER cdmuser;
GO
CREATE SCHEMA dev_raw;
CREATE SCHEMA dev_ldz;
CREATE SCHEMA dev_anp;
CREATE SCHEMA dev_rdv;
CREATE SCHEMA dev_bdv;
CREATE SCHEMA cs_360_db;
CREATE SCHEMA cdp_metadata;
CREATE SCHEMA im_cdp_db;
CREATE SCHEMA cdm_ingest_db;
CREATE SCHEMA cdm_publish_db;
CREATE SCHEMA canonical;
CREATE SCHEMA canonical_etl_db_user;
GO
No comments:
Post a Comment