Subject Re: [firebird-support] Owner of the database...
Author Thomas Steinmaurer
> Is there a way, that i can know who is the owner of the database that i m about to connect.

Connect to the database with isql and type:

show database;

> Also, is there a way that i can restrict the connection of the database for anyone except for the owner.

If you are using Firebird 2.1, then you can write an ON CONNECT trigger
which throws an exception in case of CURRENT_USER <> <your_owner>

If you have a database polluted with several owners for your objects
(tables, views) and you want to consolidate that to a new owner, then
write me an email and I will give the download like to my
FBOwnerMigrator tool.

HTH.

--
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
My blog:
http://blog.upscene.com/thomas/