Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-13184

ALTER USER SET PASSWORD is valid syntax but does not find user

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 2.8.1
    • Fix Version/s: None
    • Component/s: security, sql
    • Labels:
      None
    • Ignite Flags:
      Docs Required, Release Notes Required

      Description

      I have noticed the following:

      1: jdbc:ignite:thin://localhost> ALTER USER "ignite" set password 'abcdefg' ;    
      Error: Failed to parse query. Пользователь "ignite" не найден
      User "ignite" not found; SQL statement:
      ALTER USER "ignite" set password 'abcdefg'  [90032-197] (state=42000,code=1001)
      

      The correct syntax is "WITH PASSWORD" but using "SET PASSWORD" does not cause parse error (like LIMIT PASSWORD or WHERE PASSWORD) would. It will report that user does not exist, which is false, and can probably throw an user off.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              ilyak Ilya Kasnacheev
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: