Set up a read-only user in the CommServe server
The Data Collector uses Java Database Connectivity (JDBC) as a read-only user (including executing some read-only functions) to collect point-in-time data from the Commvault Simpana CommServe database. The Data Collector also uses a Commvault Simpana command-line tool (sendLogFiles.exe - executed using WMI on the CommServe server) to collect log files from client machines managed by the CommServe server.
There are two methods to set up an optional read-only user in the CommServe database. Choose one.
Note:
MS SQL Server must be set to Mixed-mode authentication and the login to be used for collection must be using SQL authentication.
Create a new read-only user with a non-expiring password and assign the role in the CommServe database. After completing the following steps, verify the connectivity with the read-only user ID.
Grant EXECUTE permission for the following stored procedures to the new read-only user:
dbo.GetDateTime
dbo.GetUnixTime
dbo.GetJobFailureReason
dbo.JMGetLocalizedMessageFunc
There are two methods for assigning EXECUTE permission.