Let's say I have a 3 node cluster on 3.11.4 on which authentication is enabled but authorization is disabled. It has one non-super login user 'user1' and default super user 'cassandra' In cassandra.yaml authenticator: PasswordAuthenticator authorizer: AllowAllAuthorizer
So to enable authorization we change the cassandra.yaml of a node 'node1' from authorizer: AllowAllAuthorizer TO authorizer: CassandraAuthorizer You client application db operations on the node1 starts failing as soon as the cassandra restarts on that nodewith below error until you run GRANT operation for user1 after connecting with cassandra user: UnauthorizedException: User user1 has no SELECT permission on <table testtable> Is there a way to avoid this error at all in the above situation? -- regards, Laxmikant Upadhyay