Hi Alan;Here is the update after some experimenting this morning.
Error message - the error message says that the role name is already in use.Other info - Dialect:3, charset: none, role name: ttool_userI removed my second database completely and created a new one. I try to create the new same named role and get the error message noted above.Just to give it one more shot I drop the database again and create a new one. And like magic I can create the role with the same name.This would appear to be some sort of odd ball bug to me. 

--- 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, 4:43 PM


















> 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


































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