# Cis Cassandra311 3.6

> Cis Cassandra311 3.6 is an Agent Skill for devops & security published in the CyberStrikeus/CyberStrike repository on GitHub: a SKILL.md instruction file an AI agent can load to do this task.

Review User-Defined Roles

- Skill name: `cis-cassandra311-3.6`
- Category: [DevOps & Security](https://www.openparable.com/skill/devops-security/1)
- Source: https://github.com/CyberStrikeus/CyberStrike/blob/HEAD/.cyberstrike/skill/CIS_benchmarks/Server_Software/Apache_Cassandra/CIS_Apache_Cassandra_3.11_Benchmark_v1.1.0/cis-cassandra311-3.6/SKILL.md
- Repository: CyberStrikeus/CyberStrike (1,211 GitHub stars when collected)

## SKILL.md

# 3.6 Review User-Defined Roles

## Profile Applicability

- Level 1 - Cassandra
- Level 2 - Cassandra
- Level 1 - Cassandra on Linux
- Level 2 - Cassandra on Linux

## Description

The MEMBER_OF column found in the system_auth.roles table shows roles granted to roles.

## Rationale

The MEMBER_OF column shows whoever has roles granted to roles and depending on the role and the privileges grant to the role should be limited . Limiting the accounts that have the certain roles reduces the chances that an attacker can exploit these capabilities.

## Audit

Execute the following SQL statement to audit this setting:

```sql
select role, can_login, member_of from system_auth.roles;
```

Looking for can_login which tells you that role can log into cassandra and member_of is when roles are granted to roles.

## Remediation

Looking at those users from the query that have member_of that is NOT null, decide if that user truly needs that role, if not, for each user, issue the following SQL statement (replace <is_member> with the value of member_of returned by the query in the audit procedure)

## Default Value

No roles are granted to other roles by default.

## References

Not specified in the benchmark.

## CIS Controls

- v8: 16.11 Leverage Vetted Modules or Services for Application Security Components
- v7: 14.7 Enforce Access Control to Data through Automated Tools

## Profile

- Level 1 | Manual

---

Source: https://www.openparable.com/skill/devops-security/cis-cassandra311-3-6 (OpenParable). Cite the canonical URL above.