System tables for authentication and authorization
Internal authentication and authorization information is stored in the following Cassandra tables:
- system_auth.roles
-
Table that stores the role name, whether the role can be used for login, whether the role is a superuser, what other roles the role may be a member of, and a bcrypt salted hash password for the role.
- system_auth.role_members
-
Table that stores the roles and role members.
- system_auth.role_permissions
-
Table that stores the role, a resource (keyspace, table), and the permission that the role has to access the resource.
- system_auth.recqlshSourceole_permissons_index
-
Table that stores the role and a resource that the role has a set permission.
