USE [master]
CREATE ROLE [dba]
GO
ALTER AUTHORIZATION ON SCHEMA::[db_accessadmin] TO [dba]
GO
USE [master]
GO
ALTER AUTHORIZATION ON SCHEMA::[db_securityadmin] TO [dba]
GO
USE [master]
GO
ALTER AUTHORIZATION ON SCHEMA::[db_owner] TO [dba]
GO
USE [master]
GO
ALTER AUTHORIZATION ON SCHEMA::[db_backupoperator] TO [dba]
GO
USE [master]
GO
ALTER AUTHORIZATION ON SCHEMA::[db_ddladmin] TO [dba]
GO
USE [master]
GO
USE [master]
GO
ALTER AUTHORIZATION ON SCHEMA::[db_datareader] TO [dba]
GO
USE [master]
GO
ALTER AUTHORIZATION ON SCHEMA::[db_datawriter] TO [dba]
GO
USE [master]
GO
CREATE LOGIN [libras] WITH PASSWORD=N'*******' MUST_CHANGE, DEFAULT_DATABASE=[testing], CHECK_EXPIRATION=ON, CHECK_POLICY=ON
GO
USE [testing]
GO
CREATE USER [Libras] FOR LOGIN [libras]
GO
USE [testing]
GO
EXEC sp_addrolemember N'dba', N'Libras'
GO
USE [testing]
GO
GRANT UPDATE TO [dba]
GO
USE [testing]
GO
GRANT TAKE OWNERSHIP TO [dba]
GO
USE [testing]
GO
GRANT AUTHENTICATE TO [dba]
GO
USE [testing]
GO
GRANT CONNECT REPLICATION TO [dba]
GO
USE [testing]
GO
GRANT CONTROL TO [dba]
GO
USE [testing]
GO
GRANT BACKUP DATABASE TO [dba]
GO
USE [testing]
GO
GRANT CREATE AGGREGATE TO [dba]
GO
USE [testing]
GO
GRANT CREATE FULLTEXT CATALOG TO [dba]
GO
USE [testing]
GO
GRANT CREATE CERTIFICATE TO [dba]
GO
USE [testing]
GO
GRANT CREATE ASYMMETRIC KEY TO [dba]
GO
USE [testing]
GO
GRANT CREATE SYMMETRIC KEY TO [dba]
GO
USE [testing]
GO
GRANT CREATE QUEUE TO [dba]
GO
USE [testing]
GO
GRANT CREATE XML SCHEMA COLLECTION TO [dba]
GO
USE [testing]
GO
GRANT CREATE CONTRACT TO [dba]
GO
USE [testing]
GO
GRANT CREATE REMOTE SERVICE BINDING TO [dba]
GO
USE [testing]
GO
GRANT CREATE ASSEMBLY TO [dba]
GO
USE [testing]
GO
GRANT CREATE SCHEMA TO [dba]
GO
USE [testing]
GO
GRANT CREATE FUNCTION TO [dba]
GO
USE [testing]
GO
GRANT CREATE DATABASE DDL EVENT NOTIFICATION TO [dba]
GO
USE [testing]
GO
GRANT CREATE DEFAULT TO [dba]
GO
USE [testing]
GO
GRANT CREATE PROCEDURE TO [dba]
GO
USE [testing]
GO
GRANT CREATE RULE TO [dba]
GO
USE [testing]
GO
GRANT CREATE ROLE TO [dba]
GO
USE [testing]
GO
GRANT CREATE ROUTE TO [dba]
GO
USE [testing]
GO
GRANT CREATE SERVICE TO [dba]
GO
USE [testing]
GO
GRANT CREATE SYNONYM TO [dba]
GO
USE [testing]
GO
GRANT CREATE TABLE TO [dba]
GO
USE [testing]
GO
GRANT CREATE MESSAGE TYPE TO [dba]
GO
USE [testing]
GO
GRANT CREATE TYPE TO [dba]
GO
USE [testing]
GO
GRANT CREATE VIEW TO [dba]
GO
USE [testing]
GO
GRANT EXECUTE TO [dba]
GO
USE [testing]
GO
GRANT DELETE TO [dba]
GO
USE [testing]
GO
GRANT INSERT TO [dba]
GO
USE [testing]
GO
GRANT ALTER ANY DATABASE AUDIT TO [dba]
GO
USE [testing]
GO
GRANT ALTER ANY FULLTEXT CATALOG TO [dba]
GO
USE [testing]
GO
GRANT ALTER ANY CERTIFICATE TO [dba]
GO
USE [testing]
GO
GRANT ALTER ANY ASYMMETRIC KEY TO [dba]
GO
USE [testing]
GO
GRANT ALTER ANY SYMMETRIC KEY TO [dba]
GO
USE [testing]
GO
GRANT ALTER ANY CONTRACT TO [dba]
GO
USE [testing]
GO
GRANT ALTER ANY DATABASE DDL TRIGGER TO [dba]
GO
USE [testing]
GO
GRANT ALTER ANY REMOTE SERVICE BINDING TO [dba]
GO
USE [testing]
GO
GRANT ALTER ANY ASSEMBLY TO [dba]
GO
USE [testing]
GO
GRANT ALTER ANY DATASPACE TO [dba]
GO
USE [testing]
GO
GRANT ALTER ANY SCHEMA TO [dba]
GO
USE [testing]
GO
GRANT ALTER ANY DATABASE EVENT NOTIFICATION TO [dba]
GO
USE [testing]
GO
GRANT ALTER ANY APPLICATION ROLE TO [dba]
GO
USE [testing]
GO
GRANT ALTER ANY ROLE TO [dba]
GO
USE [testing]
GO
GRANT ALTER ANY ROUTE TO [dba]
GO
USE [testing]
GO
GRANT ALTER ANY SERVICE TO [dba]
GO
USE [testing]
GO
GRANT ALTER ANY MESSAGE TYPE TO [dba]
GO
USE [testing]
GO
GRANT ALTER ANY USER TO [dba]
GO
USE [testing]
GO
GRANT ALTER TO [dba]
GO
USE [testing]
GO
GRANT SHOWPLAN TO [dba]
GO
USE [testing]
GO
GRANT CHECKPOINT TO [dba]
GO
USE [testing]
GO
GRANT REFERENCES TO [dba]
GO
USE [testing]
GO
GRANT BACKUP LOG TO [dba]
GO
USE [testing]
GO
GRANT SELECT TO [dba]
GO
USE [testing]
GO
GRANT SUBSCRIBE QUERY NOTIFICATIONS TO [dba]
GO
USE [testing]
GO
GRANT VIEW DEFINITION TO [dba]
GO
USE [testing]
GO
GRANT VIEW DATABASE STATE TO [dba]
GO