Subject | ROLE checking during login to firebird |
---|---|
Author | Björn Reimer |
Post date | 2008-09-27T08:07:23Z |
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/
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/