[ https://issues.apache.org/jira/browse/CASSANDRA-19749?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Stefan Miklosovic updated CASSANDRA-19749: ------------------------------------------ Description: Let's have: {code} authenticator: class_name : org.apache.cassandra.auth.PasswordAuthenticator authorizer: CassandraAuthorizer role_manager: CassandraRoleManager {code} and do this: {code} cassandra@cqlsh> select * from system_auth.roles; role | can_login | is_superuser | member_of | salted_hash -----------+-----------+--------------+-----------+-------------------------------------------------------------- cassandra | True | True | null | $2a$10$sFCKeluid5MlW/Z0CU1ygO1U5qpLW4Rgivmu8rZNmNNQ8WeC2y92S {code} Then {code} cassandra@cqlsh> ALTER USER IF EXISTS this_does_not_exist SUPERUSER ; cassandra@cqlsh> select * from system_auth.roles where role = 'this_does_not_exist'; role | can_login | is_superuser | member_of | salted_hash ---------------------+-----------+--------------+-----------+------------- this_does_not_exist | null | True | null | null {code} It seems to be same behaviour for ALTER ROLE too. {code} cassandra@cqlsh> ALTER ROLE IF EXISTS this_role_is_not_there WITH SUPERUSER = true ; cassandra@cqlsh> select * from system_auth.roles where role = 'this_role_is_not_there'; role | can_login | is_superuser | member_of | salted_hash ------------------------+-----------+--------------+-----------+------------- this_role_is_not_there | null | True | null | null {code} was: Let's have: {code} authenticator: class_name : org.apache.cassandra.auth.PasswordAuthenticator authorizer: CassandraAuthorizer role_manager: CassandraRoleManager {code} and do this: {code} cassandra@cqlsh> select * from system_auth.roles; role | can_login | is_superuser | member_of | salted_hash -----------+-----------+--------------+-----------+-------------------------------------------------------------- cassandra | True | True | null | $2a$10$sFCKeluid5MlW/Z0CU1ygO1U5qpLW4Rgivmu8rZNmNNQ8WeC2y92S {code} Then {code} cassandra@cqlsh> ALTER USER IF EXISTS this_does_not_exist SUPERUSER ; cassandra@cqlsh> select * from system_auth.roles where role = 'this_does_not_exist'; role | can_login | is_superuser | member_of | salted_hash ---------------------+-----------+--------------+-----------+------------- this_does_not_exist | null | True | null | null {code} > ALTER USER IF EXISTS creates a user if it does not exist > -------------------------------------------------------- > > Key: CASSANDRA-19749 > URL: https://issues.apache.org/jira/browse/CASSANDRA-19749 > Project: Cassandra > Issue Type: Bug > Reporter: Stefan Miklosovic > Priority: Normal > > Let's have: > {code} > authenticator: > class_name : org.apache.cassandra.auth.PasswordAuthenticator > authorizer: CassandraAuthorizer > role_manager: CassandraRoleManager > {code} > and do this: > {code} > cassandra@cqlsh> select * from system_auth.roles; > role | can_login | is_superuser | member_of | salted_hash > -----------+-----------+--------------+-----------+-------------------------------------------------------------- > cassandra | True | True | null | > $2a$10$sFCKeluid5MlW/Z0CU1ygO1U5qpLW4Rgivmu8rZNmNNQ8WeC2y92S > {code} > Then > {code} > cassandra@cqlsh> ALTER USER IF EXISTS this_does_not_exist SUPERUSER ; > cassandra@cqlsh> select * from system_auth.roles where role = > 'this_does_not_exist'; > role | can_login | is_superuser | member_of | salted_hash > ---------------------+-----------+--------------+-----------+------------- > this_does_not_exist | null | True | null | null > {code} > It seems to be same behaviour for ALTER ROLE too. > {code} > cassandra@cqlsh> ALTER ROLE IF EXISTS this_role_is_not_there WITH SUPERUSER = > true ; > cassandra@cqlsh> select * from system_auth.roles where role = > 'this_role_is_not_there'; > role | can_login | is_superuser | member_of | salted_hash > ------------------------+-----------+--------------+-----------+------------- > this_role_is_not_there | null | True | null | null > {code} -- This message was sent by Atlassian Jira (v8.20.10#820010) --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org