What are the database privileges required for BV Control SQL Server
|Article:TECH147490|||||Created: 2011-01-05|||||Updated: 2011-01-05|||||Article URL http://www.symantec.com/docs/TECH147490|
Need to know what database privileges are required for configuring BV Control SQL Server
Certain minimum rights are required for querying against the data sources.
These minimum rights are required by the credentials specified in the
The following minimum user rights are required to query the SQL Server:
· The user credentials supplied (Windows user or SQL Server user) for
connecting to the SQL Server should be a user for the SQL Server.
Otherwise, the credential verification in bv-Control for Microsoft SQL
· The user credentials supplied for connecting to the SQL Server (Windows
user or SQL Server user) must have read rights on the master database. This
master database must be of the SQL Server being queried. Otherwise, the
credential verification in bv-Control for Microsoft SQL Server fails.
· To query on a particular database on SQL Server, read rights are required on
For more information on Minimum Rights required for querying data sources
and privileges required for auditing, refer to the Appendix A.
The product supports querying target SQL Servers in an untrusted domain.
Article URL http://www.symantec.com/docs/TECH147490