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.)