> Hi Alan;That doesn't work.
> DROP ROLE MY_ROLE works on the database that has this role. But CREATE
> ROLE MY_ROLE doesn't work on the second database.That's the problem I
> have.

we can’t read your mind, but I'll have a guess.
You think that by creating a role on the new database, all the grants from
the other DB will suddenly apply?

wrong.

Roles and grants are not server bound, they are database bound.
Alan