Subject Re: [firebird-support] About security and priviligies????????
Author Martijn Tonies
Hi,

> How is it possible to give some user only "browse" like right in
> mySQL when using a firebird database? It is a big problem for me.
> When I grant only "select" privilige for some spesific user, my
> application warns me by "There is no insert, update right for that
> user", and I cannot reach the database...but I granted the "select"

Why does it warn you?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com


> privilige for that user...so why????? I am only trying to make some
> user only to see some table not to meke him/her enable to change
> data on that table...
>
> I wonder if I can only do that by writing some code on my
> application? Forexample by checking username and if the current user
> is that restricted user, then making related table read only for
> him/her? But I think this is the wrong way! I can arrange it in the
> gdb file by using FB Database management huh? What should i do
> resolve that problem? Please tell me a little bit...