Subject ROLE checking during login to firebird
Author Björn Reimer
Hello,

It's a known "feaure" I think, but it's still not as it should be.

If I log on to firebird server with username, password and role and
I was not granted to the role or have misspelled the role, there is
no visible reaction of firebird.

I always have to check via
SELECT current_role FROM RDB$DATABASE
for example.

I'd expect at least a warning.

Is the behavior of firebird according to SQL standard?
Are there planes for changing the described behavior?

Of course it's not a big thing.


Björn

--
Björn Reimer, Datenbanken und Verfahren
Friedrich-Alexander-Universität Erlangen-Nürnberg
Regionales RechenZentrum Erlangen (RRZE)
Hugenottenplatz 1a, D-91054 Erlangen, Germany
Tel. +49 9131 85-26719, Fax +49 9131 85-25777
bjoern.reimer@...-erlangen.de
http://www.rrze.uni-erlangen.de/infrastruktur/datenbanken/