sql-scripts/TODO sl2007.md

a lancer dans une query ssms pour tester

tester step 19 et si ok exécuter step 22 tester aussi step 21

ALTER ROLE [db_owner] ADD MEMBER [sql-au_bag_apv]; ALTER ROLE [db_owner] ADD MEMBER [sql-repl_agent]; ALTER ROLE [db_owner] ADD MEMBER [sql-md_devs]; ALTER ROLE [db_ddladmin] ADD MEMBER [sql-bag_sl2007]; ALTER ROLE [db_datareader] ADD MEMBER [sql-au_bag_apv]; ALTER ROLE [db_datareader] ADD MEMBER [sql-bag_sl2007]; ALTER ROLE [db_datawriter] ADD MEMBER [sql-au_bag_apv]; ALTER ROLE [db_datawriter] ADD MEMBER [sql-bag_sl2007]; GRANT CONNECT ON DATABASE::[SL2007] TO [sql-au_bag_apv]; GRANT CONNECT ON DATABASE::[SL2007] TO [sql-repl_agent]; GRANT CONNECT ON DATABASE::[SL2007] TO [sql-md_devs]; GRANT CONNECT ON DATABASE::[SL2007] TO [sql-bag_sl2007];

GRANT EXECUTE ON DATABASE::[SL2007] TO [sql-bag_sl2007];