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

--- On Mon, 12/29/08, Alan McDonald <alan@...> wrote:
From: Alan McDonald <alan@...>
Subject: RE: [firebird-support] Roles
To: firebird-support@yahoogroups.com
Date: Monday, December 29, 2008, 3:13 PM


















> 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


































[Non-text portions of this message have been removed]