User privileges in Microsoft SQL-Server 2005 environments
In a properly configured CAST environment, the CAST administrator will create RDBMS logins for use with CAST products (CAST Analysis Manager, CAST Enlighten, CAST Report Center etc.) that do not have the same access privileges as the powerful "sa" or "sysadmin" logins. This is to avoid a situation where a standard user could gain access to sensitive material or configuration settings on the RDBMS.
In Microsoft SQL-Server 2005 environments, i.e. where the CAST Knowledge Base or CAST Central Site are installed on a Microsoft SQL-Server 2005, the limited logins created specifically for use with CAST products MUST be granted the VIEW SERVER STATE privilege.
This privilege grants access to the server's current process list via master..sysprocesses or via sys.dm_exec_requests. This information is required by CAST products for internal management of database locking and the analyzer save process.
To avoid product usage errors, users will be prevented from accessing the database if their login does not have access to the current process list.
