How to apply granular Sql permissions to replace the sysadmin role

Article:TECH125793  |  Created: 2010-01-12  |  Updated: 2011-12-21  |  Article URL http://www.symantec.com/docs/TECH125793
Article Type
Technical Solution

Product(s)

Environment

Issue



How to apply granular Sql permissions to replace the sysadmin role


Solution



The Sql server default permissions required for the Enterprise Vault Service Account is sys_admin.  The sys_admin permission is used to create scheduled search jobs using the Sql Server Agent.  Currently there are no supported methods to granularly apply Sql permissions to accomplish the tasks required.


Symantec Corporation has acknowledged that the above-mentioned issue is present in the current version(s) of the product(s) mentioned at the end of this article. Symantec Corporation is committed to product quality and satisfied customers.

There are currently no plans to address this issue by way of a patch or hotfix in the current or previous versions of the software at the present time. This issue may be resolved in a future major revision of the software at a later time. However, this particular issue is not currently scheduled for any release.  If you feel this issue has a direct business impact for you and your continued use of the product, please contact your Symantec Sales representative or the Symantec Sales group to discuss these concerns.  For information on how to contact Symantec Sales, please see    http://symantec.com/


 

Supplemental Materials

Value1218248
Description

Need granular SQL permissions to replace the sysadmin role


Legacy ID



345660


Article URL http://www.symantec.com/docs/TECH125793


Terms of use for this information are found in Legal Notices