Creating an audit log database

The audit log feature requires an existing external database in which to store the vault event information. By default, the Meridian FDA Module does not create this database automatically. The database must be created by a database administrator. Scripts for SQL Server and Oracle are installed by the Meridian Enterprise setup program for your convenience that will create the database and the necessary schema. The scripts must be run by a user with sufficient rights to perform the actions in the scripts.

To create an audit log database in SQL Server:

1. Copy the following script file from the Meridian Enterprise application server to the SQL Server host computer:

C:\Program Files\BC-Meridian\Program\BC Audit\BCAuditTrailDB.sql

2. On the SQL Server host computer, navigate to the folder where you copied the files in step 1.
3. Run the script using the sqlcmd command-line program and one of the following examples:

Note

• We recommend using the database name <VaultName>AuditLog.

• If the database server is running SQL Server Express, SQL Server Small Business, or another edition that creates a default named instance when the software is installed, specify the name of the database server and the SQL Server instance name together, for example, <ServerName>\SQLEXPRESS or <ServerName>\MSSMLBIZ.

sqlcmd -S <ServerName> -E -i BCAuditTrailDB.sql -v DatabaseName = "<AuditDatabaseName>"

Or to use different credentials than your own:

sqlcmd -S <ServerName> -U <UserName> -P <Password> -i BCAuditTrailDB.sql -v DatabaseName = "<AuditDatabaseName>"

To create an audit log database in Oracle:

1. Copy the contents of the following folder on the Meridian Enterprise application server to the Oracle host computer:

C:\Program Files\BC-Meridian\Program\BC Audit

2. On the Oracle host computer, navigate to the folder where you copied the files in step 1.
3. Start SQL *Plus.
4. Run the following command:

run @ORACreateTables.sql