Hi Martijn,

That's something I didn't think of, you mean you have not only to
provide the username / password but also the role ?

Dank u in advance :-)

Nico Callewaert

--- In ib-support@yahoogroups.com, "Martijn Tonies" <m.tonies@u...>
wrote:

> Hi Nico,
>
> > I don't succeed to grant privileges to a user with a ROLE. I

did

> > the following : I've created a simple table to the test,
> > named 'ROLETEST'. NCW is my username.
> >
> > 1) CREATE ROLE NEW_ROLE
> > 2) GRANT SELECT ON ROLETEST TO NEW_ROLE
> > 3) GRANT NEW_ROLE TO NCW
> >
> > When I log on with NCW and try to read from the table, I got the
> > error message : no permission for read/select access to TABLE

ROLETEST

>
> Do you also specify this role when logging on?
>
>
> With regards,
>
> Martijn Tonies
> InterBase Workbench - the developer tool for InterBase
> Firebird Workbench - the developer tool for Firebird
> Upscene Productions
> http://www.upscene.com
>
> "This is an object-oriented system.
> If we change anything, the users object."