Is it possible to "copy" a database role and all it's permissions to a new role?

Question

question

Equus asked Nov 20, '13

Is it possible to "copy" a database role and all it's permissions to a new role?

I have an existing access 2010 database with sqlserver 2008 backend. The database has several database roles one which I would like to copy along with all the permissions to a new database role. There are a lot of permissions and I don't really want to do manually if I don't have to.

roles

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey ♦♦ commented · Nov 24, 2013 at 08:31 PM

The site runs on voting. Please indicate all helpful answers by clicking on the thumbs up symbols next to those answers. Please indicate any one answer that lead to the best solution by clicking on the check mark next to that answer.

0 ·

Answer 1 · 2013-11-20T20:43:14Z

Grant Fritchey answered Nov 20, '13

There is no way through the GUI. You'll have to script something out to generate the script. I'd suggest using Powershell. I'm pretty sure you can even track down an example online if you look for it.

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Equus commented · Nov 20, 2013 at 08:44 PM

Thanks you, I will look into that!

0 ·

Answer 2 · 2013-11-20T21:50:13Z

Pavel Pawlowski answered Nov 20, '13

You can take inspiration in my blog post [Cloning user rights in database][1]. [1]: http://www.pawlowski.cz/2011/03/cloning-user-rights-database/

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Equus commented · Nov 20, 2013 at 10:18 PM

I am not sure I can access your blog, but I will give it a try. A lot of restrictions on access to certain areas on the web.

0 ·

question