I tried to find workaround for this problem and here is what I did.

I have 2 different roles(2 different access level)
OPERATER (granted to insert, update and delete data)
SUPERVIZOR (granted just to view data)

Now before I open dataset I check connection's SQLRole property and
if it is 'SUPERVIZOR' then i clear InsertSQL, EditSQL and DeleteSQL
and then server does not send error message. If i don't clear those
properties server always reports error "don't have update/write
rights"

--- In IBObjects@y..., "radevojvodic" <rvojvodic@r...> wrote:
> I have similar problem here.
> I granted Select, Reference rights on ROLE and granted ROLE to
> USERNAME, still when I try to close query I got message don't have
> update/write rights. This does not happends when i'm opening query.
> Another thing is that messages from server are ugly to see when you
> try to do operation for which you does not have right.
>
> There is one thing that should be done anyway. I think that
> IB_dataset should be aware of rights that current user have on the
> interbase table that IB_dataset uses (in the moment of opening
> dataset it should retrieve rights from server). In that case, for
> example, TIB_UpdateBar could be aware of those rigths too and
buttons
> for insert, update, delete could be disabled automaticaly if those
> rights wasn't granted to the current user.
>
> --- In IBObjects@y..., "Don Gollahon" <dlgllhn@t...> wrote:
> > Yes. And make sure you spell the role correctly (when you don't
> forget to
> > enter it altogether).
> > Big Blush....
> >
> >
> > ""Jason Wharton"" <jwharton@i...> wrote in message
> > news:024c01c1fedf$fd603f70$dc756a41@CX170673E...
> > > grant user rights of the role and specify role on login?
> > >
> > > Jason Wharton
> > > CPS - Mesa AZ
> > > http://www.ibobjects.com
> > >
> > >
> > > ----- Original Message -----
> > > From: "Don Gollahon" <dlgllhn@t...>
> > > Newsgroups: egroups.ibobjects
> > > To: <IBObjects@y...>
> > > Sent: Saturday, May 18, 2002 6:39 PM
> > > Subject: [IBO] Grant appears to fail
> > >
> > >
> > > > I granted all on a role for a table, but the login name that
> has role
> > > rights
> > > > still gets an error that says he doesn't have read/select
> rights. Got
> > any
> > > > ideas?
> > > >
> > > > IB 6.0.1 on Windows XP Home. Delphi 6 app with IBObjects.
> > > >
> > > > --
> > > >
> > > > Don Gollahon
> > > > (dlgllhn@t...)
> > >
> > >
> > >
> > >
> > >
> >
>
______________________________________________________________________
> _____
> > > IB Objects - direct, complete, custom connectivity to Firebird
or
> > InterBase
> > > without the need for BDE, ODBC or any other layer.
> > >
> >
>
______________________________________________________________________
> _____
> > > http://www.ibobjects.com - your IBO community resource for Tech
> Info
> > papers,
> > > keyword-searchable FAQ, community code contributions and more !
> > >
> > > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
> > >
> > >
> > >