I want to copy the permissions on a role to a new role in the same database. How should I do that?
I wondered about creating a query to select the permissions for the old role from system tables, and then looping through that list and for each one doing GRANT x ON y TO z ... Mind you I don't know where to find the permissions in the system tables. Is that a good idea or is there a better way?