[CREATE OR] ALTER USER statement: clause PASSWORD (if  present) must be always 
specified just after USER
--------------------------------------------------------------------------------------------------------

                 Key: CORE-5155
                 URL: http://tracker.firebirdsql.org/browse/CORE-5155
             Project: Firebird Core
          Issue Type: Bug
          Components: ISQL
    Affects Versions: 4.0 Initial, 3.0 RC2
            Reporter: Pavel Zotov
            Priority: Minor


SQL> create or alter user foo password '123' firstname 'john';
SQL> -- OK --

But: 

SQL> create or alter user foo firstname 'john' password '123';
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, column 43
-password


-- 
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

        

------------------------------------------------------------------------------
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785231&iu=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to