question

sunil281984 avatar image
sunil281984 asked Erick Ramirez answered

How do I create a user in DSE 6.8.14?

Can you provide to create user in DSE 6.8.14

authentication
10 |1000

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

starlord avatar image
starlord answered sunil281984 commented

Hi Sunil,

The use of database users has been deprecated in DSE, you should create a new role instead for any authorization/authentication needs. The doc page here should help, but let us know if there are any questions that aren't covered:

https://docs.datastax.com/en/dse/6.8/cql/cql/cql_reference/cql_commands/cqlCreateRole.html

Thanks

1 comment Share
10 |1000

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

Hello Starlord,

I have below issue when I am creating role:

cassandra@cqlsh> create role cloudiq_ro WITH SUPERUSER = False LOGIN = true PASSWORD = 'XXX_123';

SyntaxException: line 1:46 mismatched input 'LOGIN' expecting EOF (...cloudiq_ro WITH SUPERUSER = False [LOGIN]...)

cassandra@cqlsh> list all permissions of cassandra;

Unauthorized: Error from server: code=2100 [Unauthorized] message="Anonymous users are not authorized to perform this request"


Please help me out


0 Likes 0 ·
Erick Ramirez avatar image
Erick Ramirez answered

You are missing the AND operator in your command. The correct format is:

CREATE ROLE role_name
    WITH SUPERUSER = false
    AND LOGIN = true
    AND PASSWORD = 'Compl3xP@55word';

If you need other examples, have a look at the CQL CREATE ROLE page. Cheers!

Share
10 |1000

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.