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