> I need to limit database connection to a single user (excluding SYSDBA)
> I've created 2 users with gsec (ex. user1 and user2).
> I've created a database with "create database mydb user user1 password
> mypass"
> If I try to connect mydb with user2, I can do it, I can see all my
> table s (SHOW TABLES), I can see table structure (SHOW TABLE XXX).
> I don't want to permit to another user to connect to my database.

You cannot, Firebird does not (yet) have metadata and connect privileges,
only data privileges like the ones below:

> How can I do this? I've searched for privileges, but I've found only
> SELECT, INSERT, UPDATE, DELETE...

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com