Permissions for Azure SQL
-
- Last UpdatedMar 14, 2025
- 1 minute read
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:
(Replace <user_name> with the specific username you wish to grant these permissions to.)