Hi,

> I am currently using Oracle for all my database requirements. I want
> to swtich to FB.
>
> Here are a few of my requirements.
>
> Once logged in as Administator
>
> 1. how can we get list of users currently logged in?

You can only get users logged in into a specific database
by using the Services API.

> 2. how can we get list of all the database registered with FB?

Firebird doesn't have registered databases on the server
side. It does have the "aliasses.conf" file, but as far as I
know, you cannot retrieve the list from the client.

> 3. how can we get list of all the tables in a particular database?

by issueing:
select * from rdb$relations where rdb$view_blr is null
and rdb$system_flag is null or rdb$system_flag = 0

> 4. how can we get list of all the fields in a particular table?

See rdb$relation_fields


Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com