Hi,

has someone an answer for me?


am Dienstag, 27. Februar 2007 um 17:23 schrieben Sie:

> I have many DBs where not SYSDBA is owner if the DB but another valid
> user.

> On Firebird 2.0 (LI-V6.3.0.12748) I'm getting the following strange messages:



> /*******************************************************************************
> The next statement causes the following error:

> This operation is not defined for system tables.
> unsuccessful metadata update.
> user name RRZE could not be used for SQL role.
> *******************************************************************************/
> CREATE ROLE RRZE;



> Or for

> CREATE ROLE INVMASTER;

> Execute time: 00:00:00.
> Prepare time: 00:00:00.
> Plan not available.


> Executing...
> *** IBPP::SQLException ***
> Context: Statement::Execute( CREATE ROLE INVMASTER )
> Message: isc_dsql_execute2 failed

> SQL Message : -607
> This operation is not defined for system tables.

> Engine Code : 335544351
> Engine Message :
> unsuccessful metadata update
> user name INVMASTER could not be used for SQL role


> Execute time: 00:00:01.

> But: There is no User INVMASTER!
> although there are privileges for the role INVMASTER which was not
> sucessfully created.





> Tried with FlameRobin and IBExpert.

> What's wrong?

Björn

--
Björn Reimer -- R R Z E -- Datenbanken und DV-Verfahren
Tel: 09131-85-29954 Tel: 09131-85-26719
Fax: 09131 - 302941 Fax: 09131-85-26278
Martensstr. 1 / 2.021 Halbmondstr. 6-8 / 2.034
D - 9 1 0 5 8 Erlangen D - 9 1 0 5 4 Erlangen