The following permissions are required and are grouped by SQLServer version. Example scripts are provided at the end as a guideline on how to grant permissions to SQLServer.
For SQL Server versions 9, 10, and 11 set VIEW SERVER STATE permission on master database. Also, map the user for the following databases:
User mapping is required for the following tables:
For Windows authentication, map the user for access to SQL server, and to the Niscache folder of the file system on which the CA UIM robot is installed.
Note: When you grant permission to the user, the checkpoints?fg_freespace_with_avail_disk and logfile_usage_with_avail_disk does not work for the non-Administrator user.