> -----Original Message-----
> From: Paul Vinkenoog [mailto:paul@...]
> Sent: Tuesday, 27 May 2003 9:05 PM
> To: ib-support@yahoogroups.com
> Subject: [ib-support] Owner of DB (was: Firebird newbie)
>
>
> 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
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>