> 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.

What do you mean it "doesn't work"? What error are you seeing? If there's no
error, what's happening instead?

Just saying "it doesn't work" doesn't tell us what it IS doing.

Dean.