At 08:50 AM 6/04/2004 +0000, you wrote:

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

If you use an *application* that specifies a read-write transaction, then
your "select-only" user can not access the table through that
transaction. You will have to write an application that shows the data in
a read-only transaction.

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

Use read-only transactions; or write applications that can make datasets
read-only inside a read-write transaction.

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

It's usually a combination of SQL privileges and client settings
(transaction read mode and a lot of other transaction-related
things). Also, with sophisticated interface layers like IBObjects, you can
set the read privileges with extremely fine granularity.

/heLen