Re: User audit in Cassandra

2015-01-09 Thread DuyHai Doan
What you want is something like audit logger like the one provided by DSE ? ( http://www.datastax.com/2014/12/enhanced-enterprise-security-in-datastax-enterprise-4-6 ) On Thu, Jan 8, 2015 at 1:34 PM, Ajay wrote: > Hi, > > Is there a way to enable user audit or trace if we have enabled > Password

Re: User audit in Cassandra

2015-01-09 Thread Ajay
Thanks Tyler Hobbs. We need to capture what are the queries ran by a user in a session and its time taken. (don't need query plan or so). Is that possible? With Authenticator we can capture only the session creation right? Thanks Ajay On Sat, Jan 10, 2015 at 6:07 AM, Tyler Hobbs wrote: > sys

Re: User audit in Cassandra

2015-01-09 Thread Tyler Hobbs
system_traces is for query tracing, which is for diagnosing performance problems, not logging activity. Cassandra is designed to allow you to write your own Authenticator pretty easily. You can just subclass PasswordAuthenticator and add logging where desired. Compile that into a jar, put it in

User audit in Cassandra

2015-01-08 Thread Ajay
Hi, Is there a way to enable user audit or trace if we have enabled PasswordAuthenticator in cassandra.yaml and set up the users as well. I noticed there are keyspaces system_auth and system_trace. But there is no way to find out which user initiated which session. Is there anyway to find out?. Al