Subject Re: [ib-support] Re: ROLE problem
Author Martijn Tonies
Did you grant access to PUBLIC?

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

With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions

"This is an object-oriented system.
If we change anything, the users object."

> --- In, "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 ... :)