Subject Re: [Firebird-Architect] Some Sugestions for Roles
Author Jesper B. Kiær

I started looking into Firebird last year and I like it a lot !

But there where things that were a little disappointing and that surprised
me. I think it's lacking a bit in the "security department". (only limited
characters used in passwords, no groups...)

I come from Lotus Notes background (10 years) and Security features that
have been in Notes since the first release in 1989 (15 years ago!) are not
even in Firebird now. Things like Groups, Encryption

You guys proberbly laugh about Notes, but Notes was build from the very
start with great attention to security the administering of it.

I thinks it is great to step into "another room" a get inspired from time
to time. Notes is conceptually wise very beauttyful everything being a
"note".. whether it is a docuemnt, a view, a ACL or Java is all a

(Historie of Lotus Notes:

Sorry ..not trying to sell Notes. I just want Groups to get into Firebird
a soon as possible. It really makes it a lot easier to administer

PS What happened to that "Firebird Roadmap" to be released "whithin a few
weeks" (that was several months a go)

Jesper B. Kiær

Jezzper Consulting

"Martijn Tonies" <m.tonies@...> wrote on 29-07-2004 22:21:21:

> Hi,
> > Roles only get effective when you specify it during connections.
> > Firebird seems to work this way because you can have as much roles as
> > you like, so the DB cannot decide which one to use.
> >
> > I would like to suggest one "Default Role" or a Role that gets
> > effective automatically. So, you can choose between an Active or
> > Passive role when creating a new role.
> >
> > It would be very usefull for managing grants for groups of users, like
> > I have here.
> >
> > Please, feel free for comment this sugestion.
> The current ROLE mechanism works according to the SQL
> standard. A bit strange, true, but standard.
> Perhaps, when security gets renewed, a GROUP would be
> better. Any (server or database)user can be a member of
> one or more groups. Each group can have rights granted to
> it.
> With regards,
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird, MySQL & MS
> Server.
> Upscene Productions
> Yahoo! Groups Links

[Non-text portions of this message have been removed]