Subject Re: [firebird-support] Re: Database owner?
Author Frank Schlottmann-Gödde
Kjell Rilbe wrote:
> Michael Ludwig skriver:
>>
>> Kjell Rilbe schrieb am 10.09.2010 um 11:02 (+0200):
>> > Kjell Rilbe skriver:
>> > > How can I see which user is the owner of a database?
>> >
>> > Never mind, I found it:
>> > http://www.firebirdfaq.org/faq108/
>>
>> Even easier, using isql and SHOW DATABASE:
>
> Thanks. I tried it. Nice!
>
> What, exactly, does ISQL looka at to find this information? (Just
> curious...)

FOR REL IN RDB$RELATIONS WITH
REL.RDB$RELATION_NAME = "RDB$DATABASE"
if (!REL.RDB$OWNER_NAME.NULL)
{
isqlGlob.printf("%sOwner: %s%s", TAB_AS_SPACES,
REL.RDB$OWNER_NAME, NEWLINE);
}
END_FOR



mit freundlichen Grüßen
Frank Schlottmann-Gödde

--
"Fascinating creatures, phoenixes, they can carry immensely heavy loads,
their tears have healing powers and they make highly faithful pets."
- J.K. Rowling