I have a User-Defined ROLE under the database level. Is there a way to generate a script of that role with all its permissions. I ask because my manager asked me to modify the permissions within a role. So I did using the GUI. It was a lot of unchecking. Now that I have the ROLE with the correct permissions, I want to generate a script so I use it for future databases.
Thanks for the help.