If this is true than why are my users able to access tables when the
role hasn't been specified?

I have the same problem sometimes but only when creating a new user.
I use IBX to grant the role but it doesn't seem to work. Once I use
IBConsole to grant the role to the user, the user can read/write the
tables no problem... without a role specified.

Erick

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

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