I would like a user abc to access only a single keyspace and no other keyspaces in the Database. How can I achieve so?


Just as described in documentation:

GRANT <permission> ON <keyspace> TO <user>;

You need to setup authentication/authorization before, and create user/role.

  • I have done this. But the user is able to access all the keyspaces. How can I avoid this? – Subhashis Dey Dec 7 '18 at 14:25
  • How did you create the user? what LIST ALL PERMISSIONS OF <user>; shows? Have you tried to explicitly revoke permissions: cassandra.apache.org/doc/latest/cql/… ? – Alex Ott Dec 7 '18 at 14:33

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.