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-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]On Behalf Of Fabiano Bonin
Sent: Monday, December 04, 2006 3:52 PM
To: firebird-support@yahoogroups.com
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
also.
But i'm still getting the message above with some existing databases.
The
owner of all my databases is SYSDBA. I have a very small database thai i
can
send if someone think it's worth to take a look, but it is probably some
local problem...

Regards,

Fabiano.

On 12/4/06, Nando Dessena < nando@dessena. <mailto:nando%40dessena.it>
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

<http://www.firebirdsql.org/ff/foundation> sql.org/ff/foundation

> ======================================================
>
>
>

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





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