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
Toggle Comment visibility. Current Visibility: Viewable by all users

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

2 Answers

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
Toggle Comment visibility. Current Visibility: Viewable by all users

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

sunil281984 avatar image sunil281984 commented ·

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
Toggle Comment visibility. Current Visibility: Viewable by all users

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