Privileges Required for Stopping a Violations Table

To stop a violations or a diagnostics table for a given target table, you must meet one of the following requirements:
  • You must have the DBA privilege on the database.
  • You must be the owner of the target table and have the Resource privilege on the database.
  • You must have the Alter privilege on the target table and the Resource privilege on the database.