Subject | [firebird-support] CREATE ROLE |
---|---|
Author | Codebue Fabio - P-Soft |
Post date | 2009-03-20T11:28:41Z |
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@...
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@...