copy the Role

[accessman2]

Hi,

I created a Role "Students" in db1 in SQL Server, right now, I have another database db2, I want to copy the Role "Students" from db1 and paste it and its permission in the db2.
Do we have T-SQL to do that?

 

[SQL_Hell]

you should be able to figure this out for yourself really, look up the system table sysusers, syspermissions in BOL