> Hi Alan and Dean;I thought the problem would be more obvious but it
> isn't. I created two databases on the same server on another computer
> and can create roles with the same names and drop them at leisure.
> The problem computer is as described. I have two databases on the same
> server. I can create and drop roles on one database (no grants - just
> CREATE ROLE MY_ROLE) but cannot use the same role name on the second
> database. I thought it was a server problem.I will post the error
> messages tomorrow when I get back to my other computer.ThanksLin

2 databases, different dialect? reserved word for the role name? charset
issue?
Alan