Subject Re: [firebird-support] Secure DB only for the owner.
Author Fidel Viegas
On Sun, Jun 14, 2009 at 9:05 AM, d5f212<abybaby123@...> wrote:
>
>
> Hi, all
>
> What i have observed with firebird is that, immaterial of who the owner of
> your database is, your database objects can still be viewed by any user who
> is in the security database.
>
> Although any other user cannot r/w neither to these object nor to the system
> tables
>
> Is there a way by which i can restrict my DB connection for only the owner
> and no one else.
>
> Please guide.
>
> Thanking you
>

Hi Aby,

If you are using Firebird 2.1+, then you can use database triggers to
achieve that.

All the best,

Fidel.