Subject Re: [firebird-support] creating roles as no-SYSDBA-owner of a DB
Author Ivan Prenosil
> 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;

You already have user RRZE in your database
(i.e. RRZE is owner of some objects, or RRZE has granted some rights), try

SELECT * FROM RDB$USER_PRIVILEGES WHERE RDB$USER='RRZE';

Ivan
http://www.volny.cz/iprenosil/interbase/