> Hello all.
>
> (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
> :/
>
> --
> Maciej Grzywocz <emgie@...>
>

As soon as you create a user on the server, that user will be able to create
databases and create tables in databases. Access to databases they do not
create or tables they do not create are limited by the permissions (grants)
you specify.

Alan