SQL server (2008 R2 standard 64bit). I use database roles and I have assigned many rights to different objects. Examples (only read this table, only insert on one table, full rights to certain Schemas, execute certain sprocs etc....). I have more than 200 securables assigned to this Role.
How can I script this role, so that i can re-create it on a different server with all the securables to go along with it??
I really do not want to create the role from scratch and go through all the assigning of the rights to all these different objects.
many thanks in Advance!