Hi,

> (This was sent to firebird-general yesterday, because "me blind" didn't
> read carefully the group description... So, apologies...)
>
> Three days ago I downloaded Firebird 1.5 SS for Linux -- so I am a
> firebird-newbie. I have used other DBs such as Postrges and MySQL.
>
> I have a question regarding database file privileges: I am able to
> create tables in ANY database file accessible for me -- as ANY user in
> the system. For example, I can do:
>
> $ isql localhost:employee.fdb
> SQL> create table foo (id int, name varchar(30));
>
> ...without any error. The table is then owned by the user whose name is
> the same as system user name, although there is no entry in security
> table, except for SYSDBA user.
>
> I would like to control which users create tables in specified
> databases, but did not find information how to do it -- and I'm puzzled

There's currently no way to control what users can do or cannot
do with regard to creating objects.

These security issues will be handled in v2, that should have increased
security.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com