> 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?

Yes - nothing stops this if you do not adequately protect the file using the
system filesystem. Since there is absolutely no need for users to ever see
the gdb file or, witht he use of Alias configuration, even know it's
position in the filesystem, it is easy enough to fully protect it.

>
> 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?.

answered already - dleete the metadata but make sure you keep a copy and
managing metadata change after that is a little more thought provoking.

>
> 3) How does role work in FB?

The manual is very clear and concise on the topic of roles.

Alan

>
> Thank a lot
>
> Regards
> Willy
>