Subject RE: [firebird-support] CREATE ROLE PUBLICO
Author Jeff G. Larson
I got a similar error message when I had another process or application
connected to the database.

Jeff Larson, TraxCorp
107 Vista Centre Dr.
Forest, VA 24551
(434) 385-7250 x234
This message contains confidential information and is intended only for
the named recipients.

-----Original Message-----
[]On Behalf Of Fabiano Bonin
Sent: Monday, December 04, 2006 3:52 PM
Subject: Re: [firebird-support] CREATE ROLE PUBLICO

create role publico;
The next statement causes the following error:

This operation is not defined for system tables.
unsuccessful metadata update.
user name PUBLICO could not be used for SQL role.
create role publico

Strange... I created a new database and i was able to create the role
But i'm still getting the message above with some existing databases.
owner of all my databases is SYSDBA. I have a very small database thai i
send if someone think it's worth to take a look, but it is probably some
local problem...



On 12/4/06, Nando Dessena < nando@dessena. <>
it> wrote:
> Fabiano,
> F> Why can't i create a role with this name in FB 2.0?
> dunno. I can. Stating which error message you get might help you to
> get some guesses.
> --
> Nando Dessena
> ======================================================
> I support Firebird, I am a Firebird Foundation member!
> Join today at http://www.firebird
> ======================================================

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

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