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: commits-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org