pt_wico wrote:

>
> Hi All
> I've several qs on fb db security
>
> 1) Is this case possible? if I created an fdb file and then somebody
> take that file and open and manipulate using their own sysdba
> account. How to prevent this?
>

Do not give People Fileaccess to the Database Server.

> 2) I want to protect FB objects (ie tables, package, trigger) from
> being red by other unauthorized user (ie login directly using admin
> tools to database not through application), how do i do this?.
>

You can Delete the Source for Triggers and Stored Procs.
Look up the Metadata Tables for FB.
They are still stored as compiled BLR so that they can be used.

> 3) How does role work in FB?
>

I'm no expert in this one.

Uwe