DISQUS

Tech-Recipes: SQL Server 2005: Easily Grant Select to All Tables and/or Views in a Database | Database | Tech-Recipes

  • Craig · 11 months ago
    Very helpful! Thanks!
  • Marc Jellinek · 8 months ago
    ... or you could just add the login to the db_datareader role, which grants select permission to all tables and views within the database.

    ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/7d71fca8-ad8d-49c5-b4cc-c1cdab0fab43.htm
  • Sudarshan · 8 months ago
    Extremely handy script! exactly what I was looking for. Saved a lot of time.