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.

--- 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, 2:37 PM


















> Hi;

>

> I have two databases on the same server. I would like to delete/

> remove a role I created for one database and reassign that role name

> to the second database. How do I do that?

>

> Thanks

> Lin



DROP ROLE

CREATE ROLE



Alan


































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