DB Roles

Is there a way to copy a DB Role to a another DB and keep all the
Permissions assign to the role?You sure can script database roles from Enterprise Manager, by right
clicking on the database, and selecting All Tasks -> Generate SQL Scripts.
In the options tab, choose database roles.
I don't think this option scripts the permissions assigned to the roles. I
haven't tried it myself.
But for my database roles, I always create a script that creates the role,
and assigns the permissions. If I need to replicate this role on some other
database, I simply get the latest version of this script from VSS and run it
against that database.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"Yovan Fernandez" <yfernandez@.sai-inc.com> wrote in message
news:t_08b.1183$ev2.814323@.newssrv26.news.prodigy.com...
Is there a way to copy a DB Role to a another DB and keep all the
Permissions assign to the role?