Skip to content
Related Articles
Open in App
Not now

Related Articles

Granting Permissions to Roles in Cassandra

Improve Article
Save Article
  • Last Updated : 05 Jun, 2020
Improve Article
Save Article

In this article, we are going to discuss how we can granting permission to roles in Cassandra. First, we will create a new role and show how it can access the database.

Creating a new role:
In this step, we are going to create a new role such that user_access is a new role and want to access the database. To create a new role using the following cqlsh query.

cassandra@cqlsh> create role user_access
   ... with password = 'user_access'
   ... and LOGIN = true;

Output:

Now, If we can see “user_access” role access by using the following cqlsh query.

cassandra@cqlsh> list all permissions of 'user_access';

 role | resource | permissions
------+----------+-------------

(0 rows)
cassandra@cqlsh>

Right now, it can’t access the Existing keyspace ‘University’. let’s have a look.

cassandra@cqlsh> login user_access
Password:user_access
user_access@cqlsh>

Output:

To resolve this error “Unauthorized: Error from server: code=2100 [Unauthorized] message=”User user_access has no SELECT permission on

or any of its parents” we can give the grant permissions to access.

Consider if we want only access “student” table on university keyspace then we can use the following cqlsh query.

cassandra@cqlsh>

grant all permissions on university.student to user_access;

Only we can grant permission to access “university.student” table.

Output:

Now, used the following cqlsh query if we want to give the grant access to all tables on a university keyspace.

cassandra@cqlsh>

grant all permissions on keyspace university to user_access;

We can see all the permissions by using “list all permissions”.

Output:

If we want to give the grant access to the full database then used the following cqlsh query.

cassandra@cqlsh>

grant all permissions on all keyspaces to user_access;

Output:

My Personal Notes arrow_drop_up
Next
Internet: Boon or Bane?
Related Articles
1. Database Roles in CQL (Cassandra Query Language)
2. SQL | Creating Roles
3. Key Roles for Data Analytics project
4. What Are the Roles and Responsibilities of a Data Scientist?
5. Privilege and Roles in DBMS
6. 7 Most In-Demand Digital Marketing Job Roles For Freshers
7. Different job roles in Blockchain Technology
8. What are different roles in DevOps ?
9. 7 Most Demanded Job Roles in Artificial Intelligence
10. Different Job Roles In Cyber Security
Article Contributed By :
https://media.geeksforgeeks.org/auth/avatar.png
Ashish_rana
@Ashish_rana
Vote for difficulty
Improved By :
Article Tags :
Practice Tags :
Report Issue
We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy
Lightbox

Start Your Coding Journey Now!