Subject | Re: [firebird-support] How to determine database/object owner |
---|---|
Author | Thomas Steinmaurer |
Post date | 2007-02-28T21:03:48Z |
> How can I find out the owner of a database or an object?To get the owner of the database, connect via isql to the database and
execute:
show database;
To get the owner of objects, query the rdb$owner_name field in different
system tables, for instance rdb$relations and/or rdb$procedures.
--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com