Subject [ib-support] Owner of DB (was: Firebird newbie)
Author Paul Vinkenoog
Hi Alan,

> What's the quickest way to check who the owner of the DB is?

I go for:

select rdb$owner_name from rdb$relations
where rdb$relation_name = 'RDB$DATABASE'

You can use any system table name instead of RDB$DATABASE.
Or use FIRST 1 ... WHERE RDB$SYSTEM_FLAG = 1
(this must be the fastest on FB).

Only if someone deliberately tweaks the database so that not every
system table has the same owner, there's confusion.

> Is it the user who user who is the grantor of the roles?

There can be a lot of role grantors in the db.


Greetings,
Paul Vinkenoog