Page History
...
- In the Explore Activity tree, select the SQL Server instance that hosts the new database.
- Select Audited Database from the New drop-down.
- Select the user databases you want to audit, and then click Next.
- Select which audit collection level you want to use, and then click Next.
- If you chose to use the Custom audit collection level , select the appropriate audit settings for these databases, and then click Next. SQL CM SQL Compliance Manager audits only the activities and results you select. For information, see Database-level audit settings.
- If you chose to use the Custom audit collection level and you are auditing DML and SELECT events , select the objects SQL CM SQL Compliance Manager should audit for these events, and then click Next.
- If you chose to use the Custom audit collection level , select any trusted users you do not want to audit, and then click Next.
- Trusted users are database users, SQL Server logins, or members of SQL Server roles that you trust to read, update, or manage a particular audited database. SQL CM Compliance Manager does not audit trusted users. Trusted users are designated on the Add Trusted Users window of the New Audited Database wizard.
- If you are auditing privileged user activity and the trusted user is also a privileged user , SQL CM Compliance Manager continues to audit this user because of its elevated privileges. For example, a service account that is a member of the sysadmin fixed SQL Server role will continue to be audited even though the account is designated as trusted.
- Click Finish.
...
To enable database auditing and apply the Typical (default) audit settings:
- Use the SQL CM Compliance Manager setup program to manually deploy the SQLcompliance Agent to the instance that hosts the target database.
- In Windows Command Prompt, use the following syntax:
SQLcmCmd [-host CollectionServer] [-port number] auditdatabase instance database
.
To enable database auditing and apply a HIPAA or PCI regulation guideline:
- Use the SQL CM Compliance Manager setup program to manually deploy the SQLcompliance Agent to the instance that hosts the target database.
- In Windows Command Prompt, use the following syntax:
SQLcmCmd [-host CollectionServer] [-port number] auditdatabase instance database -Regulation {PCI | HIPAA | PCI, HIPAA}
.
...
Info |
---|
The SOX regulation guidelines is provided as an XML template ( |
- Use the SQL CM Compliance Manager setup program to manually deploy the SQLcompliance Agent to the instance that hosts the target database.
- In Windows Command Prompt, use the following syntax:
SQLcmCmd [-host CollectionServer] [-port number] auditdatabase instance database -config "SOX regulation guideline file path"
.
...
- Determine which currently audited database has the audit settings you want to apply to the new database.
- Export your audit settings from the source database.
- Use the SQL CM Compliance Manager setup program to manually deploy the SQLcompliance Agent to the instance that hosts the target database.
- In Windows Command Prompt, use the following syntax:
SQLcmCmd [-host CollectionServer] [-port number] auditdatabase instance database -config "exported audit settings file path"
.
...