inancakcan schrieb:

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

GRANT SELECT ON <TABLE> TO USER
is the right way to do.

You can also think about using ROLES, granting the SELECT to a ROLE and
GRANT the ROLE to USERs. But then you've got to login not only with the
Username but also with the Rolename.

(In addition to that you can also use views with the needed grants so
you just have to add grant rights to the view but not the tables itself).

With which tool are you granting the select?
I've never seen the error message you described before.

You wrote: "my application warns me"
Is it possible that you use a "live" Query (with RequestLive set to
true) for selecting the data? (This won't work: if the query is set to
be able to do updates then you can't open it without an error if you
haven't got any update rights on the underlying table)

What do you mean with "I cannot reach the database" ?

Are you sure you don't have any writes to the database after connecting?

Luc.