locked
About data reader permission RRS feed

  • Question

  • Is data reader permission to that database enough to give user  READ access on ALL objects (Tables/Views/Functions/Stored_Procedures) under that database ? or need something different?

    Thanks

    Friday, January 31, 2014 5:51 PM

Answers

  • Is data reader permission to that database enough to give user  READ access on ALL objects (Tables/Views/Functions/Stored_Procedures) under that database ? or need something different?

    Thanks


    Members of datareader role can run select statement on table and views( user yables an views ) .They can also view functions .But as Lori mentioned to execute a proc you explicitly require execute permission

    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    Friday, January 31, 2014 10:00 PM

All replies

  • Stored Procedures and UDFs require EXECUTE permissions.
    Friday, January 31, 2014 6:02 PM
  • Is data reader permission to that database enough to give user  READ access on ALL objects (Tables/Views/Functions/Stored_Procedures) under that database ? or need something different?

    Thanks


    Members of datareader role can run select statement on table and views( user yables an views ) .They can also view functions .But as Lori mentioned to execute a proc you explicitly require execute permission

    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    Friday, January 31, 2014 10:00 PM