Subject | Re: [firebird-support] creating roles as no-SYSDBA-owner of a DB |
---|---|
Author | Ivan Prenosil |
Post date | 2007-03-02T14:16:41Z |
> On Firebird 2.0 (LI-V6.3.0.12748) I'm getting the following strange messages:You already have user RRZE in your database
> /*******************************************************************************
> 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;
(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/