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.
2. 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.
Option 1: Execute SQL commands in the CommServe database
GRANT EXECUTE ON CommServ.dbo.GetDateTime TO <ro user>;
GRANT EXECUTE ON CommServ.dbo.GetUnixTime TO <ro user>;
GRANT EXECUTE ON CommServ.dbo.GetJobFailureReason TO <ro user>;
GRANT EXECUTE ON CommServ.dbo.JMGetLocalizedMessageFunc TO <ro user>;
Note: Replace <ro user> with the read-only user.
Option 2: Use MSSQL Management Studio
1. Click Databases > CommServe > Security > Users.
2. Select ro in the Users folder and double-click. The Database User screen is displayed.
3. Select the
Securables page.
4. Click Search.
5. Add specific objects.
6. Check Object Type
Scalar functions and
click
OK.
7. Enter the object name
GetDateTime and click
OK.
8. Grant execute permissions for GetDateTime by clicking Execute. Click OK.
9. Repeat steps 4-8 for each function:
• GetUnixTime
• GetJobFailureReason
• JMGetLocalizedMessageFunc
Verify Connectivity with the Read-Only User ID
Using SQL Server Management Studio, verify that you can connect and log in to the CommServe SQL database instance using this newly create User ID.
