No I did not. If I did, than any new user would be able to access the
tables.

1) I set up a role called 'sysuser' which has privileges to all the
tables
2) Whenever a new user is created, I use IBSQL to 'GRANT sysuser TO
username'.
3) Sometimes the new user can't access the tables.
4) If I go into IB Console and do the 'GRANT ...' then the new user
can access the tables.

On login... no role has been assigned.

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

> 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
> http://www.upscene.com
>
> "This is an object-oriented system.
> If we change anything, the users object."
>
> > --- 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 ... :)