what is the way to fetch Administrative Activities
Summary:
We are looking to fetch the below columns
1.User & Role Management
USER_CREATED
USER_MODIFIED
USER_DELETED
PASSWORD_RESET
ROLE_ASSIGNED
ROLE_REVOKED
PERMISSIONS_GRANTED
PERMISSIONS_REVOKED
2.Database & Object Management
SCHEMA_CREATED
SCHEMA_MODIFIED
SCHEMA_DELETED
TABLE_CREATED
TABLE_MODIFIED
TABLE_DELETED
VIEW_CREATED
VIEW_MODIFIED
VIEW_DELETED
3. Data Management
DATA_INSERT
DATA_UPDATE
DATA_DELETE
DATA_EXPORT
DATA_IMPORT
4. Security & Access Control
LOGIN_SUCCESS
LOGIN_FAILURE
MULTIPLE_FAILED_LOGINS
ACCOUNT_LOCKED
PRIVILEGED_ACCESS_GRANTED
PRIVILEGED_ACCESS_REVOKED
5. System & Configuration Changes
SYSTEM_CONFIGURATION_CHANGED
AUDIT_POLICY_CHANGED
LOG_RETENTION_POLICY_UPDATED
DATABASE_BACKUP_STARTED
DATABASE_BACKUP_COMPLETED
DATABASE_RESTORE_STARTED