Subject | [ib-support] Owner of DB (was: Firebird newbie) |
---|---|
Author | Paul Vinkenoog |
Post date | 2003-05-27T11:04:35Z |
Hi Alan,
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.
Greetings,
Paul Vinkenoog
> 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