venky created CASSANDRA-14386:
---------------------------------
Summary: Authentication issue
Key: CASSANDRA-14386
URL: https://issues.apache.org/jira/browse/CASSANDRA-14386
Project: Cassandra
Issue Type: Bug
Reporter: venky
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
-----------+-------+-------+---------
appuser | False | False | {}
appuser1 | False | False | {}
appuser2 | False | False | {}
cassandra | True | True | {}
odpuser | False | True | {}
odpuser2 | True | True | {}
readuser | False | True | {}
sparkuser | 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
-----------+-----------+--------------+-----------+--------------------------------------------------------------
odpuser | True | False | null |
$2a$10$mXJYFpGGAoX/Cc6xAsbideVrN14eE3mB4prsc2C5DS4NVg4MjjiJi
appuser2 | True | True | null |
$2a$10$yS6/mWev4KsDIm14kj8mrOjlhEbxthsDbuc/erd2DlcvqentJJ.Wu
cassandra | True | True | null |
$2a$10$FEAbfdEKW7Zh6PyxSEFYXuZCf9eHVRi55hG/BVz57XjUcVdwk2xQG
odpuser2 | True | True | null |
$2a$10$7fKa8SZ0DMCn.Aat33Qhr.I3yVafMln/jhTqbmYGx7UG8Klv97rWW
appuser1 | True | True | null |
$2a$10$9tNRhH84YZjPRLrmaMY5MulS/1N53aB.ZLwEKHbjz0NBjZE/CvyRy
sparkuser | True | False | null |
$2a$10$4rjlX7pVnfQbCJVf/RPEGOqslxZTCylb4FjLBo8GtcjvBGP1eZWNW
readuser | True | False | null |
$2a$10$zczy9A.1iBciDQgqtAtk/.zdn.kdXr7QiqfMoiYV9TECWz21Iy2I2
appuser | 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
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
