Details
-
Bug
-
Status: Resolved
-
Normal
-
Resolution: Invalid
-
None
-
None
-
None
-
Normal
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