Revised: Creating ROLE with OPTIONS is not supported

ScyllaDB
, ,
1

Installation details
#ScyllaDB version: Scylla Enterprise 2024.2.6
#Cluster size: 3 nodes (i4i.large)
os (RHEL/CentOS/Ubuntu/AWS AMI):

When I execute this query to create a role, it returns an error stating OPTIONS option is not supported

CREATE ROLE IF NOT EXISTS test_expiry WITH PASSWORD = 'password' AND LOGIN = true AND OPTIONS = { 'expires_in': 86400 };

Am I doing it wrong?
I was just referring to the official documentation

2

Hi,

The OPTIONS option is indeed not supported.

based on your example, omitting the OPTIONS portion:

scylla@cqlsh> list roles;

 role        | super | login | options
-------------+-------+-------+---------
 scylla      |  True |  True |        {}
 test_expiry | False |  True |        {}

(2 rows)

Which may lead to conclusion that OPTIONS is indeed supported; however the below shows there is no column to store those options

scylla@cqlsh> select * from system.roles;

 role        | can_login | is_superuser | member_of | salted_hash
-------------+-----------+--------------+-----------+------------------------------------------------------------------------------------------------------------
 scylla      |      True |         True |      null | $6$Ra9.AnDvolu1JY4G$DGJu3i7MeypQePpRxNbmycmEJoVmbfKorr7Wqpw6qLOJR/E4VfQr8b4YEz67.DBNfyDWAUBKX6psTmdR.Nu4m.
 test_expiry |      True |        False |      null | $6$XTvMtLXiD2xunnD8$KZ3LliYaNQkGRT/t.f6Hx0kl.qn0/bFOSSj7RjhIUEZ6FrwBmBg/RLVcv1bcbW52HeEmO9ksv6vWPwxqx89u1.

(2 rows)

cc @tzach

1 Like