Database Reference
In-Depth Information
Viewing permissions
Much like user accounts, permissions are stored in a human-readable way in a Cassandra
table, in this case the permissions table. We can see the effects of the permissions that we
granted by reading from this table:
SELECT * FROM "system_auth"."permissions";
We'll see a row for each of the permissions we've granted:
Note that the
resource
column contains a path to the keyspace or column family that the
user has permissions on, and that the permissions column is in fact a set column. Note also
that the
cassandra
user does not appear in this list; as a superuser, the
cassandra
user
automatically has permission to do anything it wants, and does not need explicit authoriza-
tion of the kind stored in the permissions table.
