Subject [firebird-support] CREATE ROLE
Author Codebue Fabio - P-Soft
I have firebird 2.1.1 installed with some databases on it...

I need to create a role to a new database.

I had 3 database when I created a role called 'UTENTI_GO'.
Now I add a new database arc3 but I don't see this role with it, so I wanna
associate role to database with the same name.

Infact if I try to create it with this instruction
CREATE ROLE UTENTI_GO
And I receive this error:

"This operation is not defined for system tables.
unsuccessful metadata update.
user name UTENTI_GO could not be used for SQL role."

I understand that roles are unic and associated with databases, but how can
associate them to databases?


Codebue Fabio
.--------------------------------.
P-Soft di Codebue Fabio & C. sas
via B.Storti, 19
24060 Chiuduno - BG
Phone: +39.035.839435
Mobile: +39.348.3515786
Fax: +39.030.5100306
.-----------------------------.
Web : www.p-soft.biz
EMail: f.codebue@...