Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Invalid
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      Hi,

      I am having an issue while I'm creating the users/roles in Cassandra Version 3.11.0 (DataStax 5.1.2).

      ``` 
      cassandra@cqlsh> list ROLES ;

      role | super | login | options
      ----------+--------------------
      user | False | False | {}
      user1 | False | False | {}
      user2 | False | False | {}
      cassandra | True | True | {}
      user3 | False | True | {}
      user4 | True | True | {}
      user5 | False | True | {}
      user6 | False | False | {}

      Here, I am getting `Login=False` and I tried with the option `Login = True` but still I am getting false. And When I select the system_auth> SELECT * FROM roles; and there I am seeing `login = True` 

      cassandra@cqlsh:system_auth> SELECT * FROM roles;

      ```

      role | can_login | is_superuser | member_of | salted_hash
      ----------+-----------------------+------------------------------------------------------------------------
      user | True | False | null | $2a$10$mXJYFpGGAoX/Cc6xAsbideVrN14eE3mB4prsc2C5DS4NVg4MjjiJi
      user1 | True | True | null | $2a$10$yS6/mWev4KsDIm14kj8mrOjlhEbxthsDbuc/erd2DlcvqentJJ.Wu
      cassandra | True | True | null | $2a$10$FEAbfdEKW7Zh6PyxSEFYXuZCf9eHVRi55hG/BVz57XjUcVdwk2xQG
      user2 | True | True | null | $2a$10$7fKa8SZ0DMCn.Aat33Qhr.I3yVafMln/jhTqbmYGx7UG8Klv97rWW
      user3 | True | True | null | $2a$10$9tNRhH84YZjPRLrmaMY5MulS/1N53aB.ZLwEKHbjz0NBjZE/CvyRy
      user4 | True | False | null | $2a$10$4rjlX7pVnfQbCJVf/RPEGOqslxZTCylb4FjLBo8GtcjvBGP1eZWNW
      user5 | True | False | null | $2a$10$zczy9A.1iBciDQgqtAtk/.zdn.kdXr7QiqfMoiYV9TECWz21Iy2I2
      user6 | True | True | null | $2a$10$Fdhz9qriq952hJs2D23uuOdMldJJg5jauxjVtJMrCNUBAef.vLcci

      (8 rows)

      ```
      And I tried to drop that user (which is having Login = False)  but it is also not working.

      ```
      cassandra@cqlsh:system_auth> DROP USER sparkuser;
      InvalidRequest: Error from server: code=2200 [Invalid query] message="sparkuser doesn't exist"
      cassandra@cqlsh:system_auth> drop role sparkuser;
      InvalidRequest: Error from server: code=2200 [Invalid query] message="sparkuser doesn't exist"
      ```
      Can anyone help me to solve this issue ASAP.

      Thank you

       

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              alokamvenki venky
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: