<div>
You can give to an user the <b>db_datareader</b> role permission but this is only to read data (table and views). For stored procedure and functions you need to grant execute permission for each created object.
</div>


You can give to an user the db_datareader role permission but this is only to read data (table and views). For stored procedure and functions you need to grant execute permission for each created object.

<div>
Can we use TSQL to loop through all the user defined SQL Procedure and grant it to a user ? There are over a hundred of procedures ...<br />
<br />
Tks
</div>


Can we use TSQL to loop through all the user defined SQL Procedure and grant it to a user ? There are over a hundred of procedures ...

Tks

<div>
use &nbsp;GRANT EXECUTE ON SCHEMA::dbo TO USER
</div>


use  GRANT EXECUTE ON SCHEMA::dbo TO USER

<div>
Tks, in case only need to explicitly grant few stored procedure to a user. How to achieve it ?
</div>


Tks, in case only need to explicitly grant few stored procedure to a user. How to achieve it ?

<div>
<div class="content wysiwyg-content">
How to grant a user to have read access to all object in a MS SQL 2008 R2, including the stored procedure created by other ?<br />
<br />
Tks
</div>
</div>


How to grant a user to have read access to all object in a MS SQL 2008 R2, including the stored procedure created by other ?

Tks

Grant read access to SQL Management Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.