[CASSANDRA-12151] Audit logging for database activity

• Type: New Feature
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 4.0-alpha1, 4.0
• Labels: fqltool
• Assignee: Vinay Chella
• Reporter: stefan setyadi

Authors

Vinay Chella

Reviewers

Jason Brown

• Created: 08/Jul/16 11:55
• Updated: 15/May/21 01:49
• Resolved: 11/May/18 12:48

Description

we would like a way to enable cassandra to log database activity being done on our server.

It should show username, remote address, timestamp, action type, keyspace, column family, and the query statement.
it should also be able to log connection attempt and changes to the user/roles.

I was thinking of making a new keyspace and insert an entry for every activity that occurs.
Then It would be possible to query for specific activity or a query targeting a specific keyspace and column family.

Issue Links

• is depended upon by: CASSANDRA-13668 Diag. events for user audit logging
• links to: CASSANDRA-12151