Powered by Zoomin Software. For more details please contactZoomin

Database Activity Monitoring User Guide

Source Type
Application Security
Data Security
Network Security
Application Performance
Product Versions
Hypervisor Installation
Document Type
Public Cloud
    Community Content Type
      Product Area
      This guide
      Table of Contents

      Permissions for Azure SQL

       Permissions for Azure SQL

      To have the necessary permissions to select data from all relevant objects within the database, you need the db_datareader database role. This role automatically provides the SELECT permissions on all tables and views.

      You can add a user to the db_datareader role using the following command:

      EXEC sp_addrolemember 'db_datareader', '<user_name>';

      (Replace <user_name> with the specific username you wish to grant these permissions to.)

      Was this topic helpful?