iConsole Search Definition Reference Guide › Standard SQL Helper Functions › Logging

Logging

The logging functions are used for debugging and problem solving. Because logging requires permission to write to the file system on the database server, additional configuration is required as follows:

Oracle

Logging uses DIRECTORY objects to define the location of the log files. These objects must pre-exist, or the privilege CREATE ANY DIRECTORY must be granted to the CA DataMinder user accounts.

SQL Server

OLE Automation must be enabled. This requires two steps:

1. Enable OLE Automation (as sa):

   exec sp_configure 'show advanced options', 1 
   reconfigure exec sp_configure 'OLE Automation Procedures', 1 
   reconfigure 
   

2. Grant access to OA methods (as sa):

   use master 
   grant execute on [sys].[sp_OACreate] to [public] 
   grant execute on [sys].[sp_OAMethod] to [public] 
   grant execute on [sys].[sp_OADestroy] to [public] 
   grant execute on [sys].[sp_OAGetErrorInfo] to [public]