Rename DB Role?

I need to rename a role in a database.

I could not find how using the BOL.

Is this possible?

This role has extensive premissions over hundreds of tables so if at all possible I do not want to simply create a new role with the new name and hope I click the appropriate permissions.

Thanks for the help.
LVL 1
sifuhallAsked:
Who is Participating?
 
NetminderConnect With a Mentor Commented:
User resolved; closed, 250 points refunded.

Netminder
Site Admin
0
 
chaniewskimCommented:
Which RDBMS?
0
 
sifuhallAuthor Commented:
SQL Server 2000.

I have solved this problem by scripting the existing role, changing the name, executing the script and dropping the previous role.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.