Subject Re: Database Trigger - Is is possible to preventing disable db trigger from ISQL?
Author trskopo
Dear Thomas Steinmaurer,

Thanks for your reply.

I don't give SysDba password to users, but since Firebird is freely available, it is easy for users to install Firebird in his/her computer and copy my database to this computer and then disable triggers in my database using his/her new SysDba password.

Best regards,
Sugiarto

--- In firebird-support@yahoogroups.com, Thomas Steinmaurer <ts@...> wrote:
>
> > For a security reason, I wrote a database triggers. It can prevent unauthorized users to connect to database.
> >
> > Access from application or database managers (such as flamerobin/others) can be blocked if needed.
> >
> > But the problem is, users can disable / set inactive my db triggers via ISQL.
> >
> > Any suggestions to prevent this?
>
> Only SYSDBA or the database owner are allowed to do that, so don't give
> that information to your normal users.
>
>
> --
> With regards,
>
> Thomas Steinmaurer
> Upscene Productions
> http://www.upscene.com
> http://blog.upscene.com/thomas/
>
> Download LogManager Series, FB TraceManager today!
> Continuous Database Monitoring Solutions supporting
> Firebird, InterBase, Advantage Database, MS SQL Server
> and NexusDB!
>