[
https://issues.apache.org/jira/browse/CASSANDRA-12151?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
stefan setyadi updated CASSANDRA-12151:
---------------------------------------
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.
was:
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.
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 activity targeting a specific keyspace
and column family.
> Audit logging for database activity
> -----------------------------------
>
> Key: CASSANDRA-12151
> URL: https://issues.apache.org/jira/browse/CASSANDRA-12151
> Project: Cassandra
> Issue Type: New Feature
> Reporter: stefan setyadi
> Fix For: 3.x
>
>
> 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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)