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
Article Type
Technical Solution


Issue



Need to know what database privileges are required for configuring BV Control SQL Server


Solution



Certain minimum rights are required for querying against the data sources.

These minimum rights are required by the credentials specified in the

Credentials Database.

 

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

Server fails.

·         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

that database.

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


Terms of use for this information are found in Legal Notices