Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-12151

Audit logging for database activity

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Resolved
    • Normal
    • Resolution: Fixed
    • 4.0-alpha1, 4.0
    • None

    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.

      Attachments

        1. DesignProposal_AuditingFeature_ApacheCassandra_v1.docx
          370 kB
          Anuj Wadehra
        2. CASSANDRA_12151-benchmark.html
          403 kB
          Vinay Chella
        3. 12151.txt
          16 kB
          stefan setyadi

        Issue Links

          Activity

            People

              vinaykumarcse Vinay Chella
              stefan setyadi stefan setyadi
              Vinay Chella
              Jason Brown
              Votes:
              9 Vote for this issue
              Watchers:
              35 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: