22 lines
819 B
Markdown
22 lines
819 B
Markdown
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]; |