Hi,

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

Yes - you need to specify it...

With InterBase/Firebird, when you have been granted a role, you
don't automatically have all rights, you need to specify the role when
connecting. You can use only 1 role at a time...

Personally, I would like to see some security things as "groups"
that you get the rights from as soon as you connect ... :)


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

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