Subject | Re: [firebird-support] Re: Database owner? |
---|---|
Author | Frank Schlottmann-Gödde |
Post date | 2010-09-13T17:35:05Z |
Kjell Rilbe wrote:
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
> Michael Ludwig skriver:FOR REL IN RDB$RELATIONS WITH
>>
>> 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...)
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