Make message about missing password being always displayed as reply on attempt
to issue CREATE new login without PASSWORD clause
--------------------------------------------------------------------------------------------------------------------------------
Key: CORE-4841
URL: http://tracker.firebirdsql.org/browse/CORE-4841
Project: Firebird Core
Issue Type: Improvement
Components: Security
Affects Versions: 3.0 Beta 2
Reporter: Pavel Zotov
Priority: Minor
SQL> create user u01; ------------------------------------------------- [ 1 ]
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -104
-Unexpected end of command - line 1, column 13
SQL> create or alter user u01; --------------------------------------- [ 2 ]
Statement failed, SQLSTATE = 42000
unsuccessful metadata update
-ALTER USER U01 failed
-ALTER USER requires at least one clause to be specified
SQL> create or alter user u01 firstname 'john'; ---------------------- [ 3 ]
Statement failed, SQLSTATE = 23000
add record error
-validation error for column "PLG$USERS"."PLG$PASSWD", value "*** null ***"
SQL> create user u01 revoke admin role; ------------------------- [ 4 ]
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, column 17
-revoke
SQL> create or alter user u01 revoke admin role; ------------------------ [ 5 ]
Statement failed, SQLSTATE = 23000
add record error
-validation error for column "PLG$USERS"."PLG$PASSWD", value "*** null ***" //
same for 'grant admin role;'
All five messages appear due to missing 'password' clause. Messages in [3] and
[5] looks more informative than other, but it would be nice if text will be
more appropriate for end-user, like: 'missing password clause' or so.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
