Powered by Zoomin Software. For more details please contactZoomin

Database Activity Monitoring User Guide

Filters

Clear All Filters
Source Type
Application Security
Data Security
Network Security
Application Performance
Product Versions
Hypervisor Installation
Document Type
Public Cloud
    Community Content Type
      Product Area
      Clear All Filters
      This guide

      Permissions for MSSQL 2008 and Higher Database Assessments

      Save PDF
      Save selected topicSave selected topic and subtopicsSave all topics
      Share
      Share to emailCopy topic URL
      Feedback
      Print
      Table of Contents
      HomeDatabase Activity Monitoring User Guide...Required PermissionsRequired Permissions for AssessmentPermissions for MSSQL 2008 and Higher Database AssessmentsCurrent page
      Table of Contents

      Permissions for MSSQL 2008 and Higher Database Assessments

       Permissions for MSSQL 2008 and Higher Database Assessments

      Database Assessments using MSSQL 2008 can be executed using a dedicated role that has permissions on the relevant database objects and a user that holds the role. The user and role should be created for each database in the server instance. Then, those users are mapped to a login that is used for the assessment process.

      For the full list of required permissions, see Required Permissions for MSSQL 2008 and Higher Database Assessments

      Notes:

      • When you run the DISA (STIG) assessment policy, if you do not use a login that has the Control Server permission or is a member of the SYSADMIN server role, you can execute the scan using the minimum permissions explained below. In such a case, there may be errors from a few of the policy's tests.
      • To run the seven tests in the policy Password Strength Assessments for MS-SQL 2005 and Above, the user must use a login that has the Control Server permission or is a member of the SYSADMIN server role, otherwise errors will be generated.
      • In the commands below, the square brackets and their contents are not variable markers but are part of the syntax of the command set.
      • MSSQL OS assessments can be conducted only with an account that has administrative privileges.

       

      Was this topic helpful?
      LikeDislike