On 6 Apr 2004 at 8:50, inancakcan wrote:

>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"
>privilige for that user...so why?????

I think it is a "feature" of your FB access components. Most likely
they are trying to prepare all queries at once...

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

Granting only "select" is the right way to accomplish this.

>I wonder if I can only do that by writing some code on my
>application?

Actually, I'd say that you must delete some code from your
application... Make your DataSets readonly, for example. Change
components library. I didn't have such problems, using FIB+.

SY, Dimitry Sibiryakov.