DISQUS

DISQUS Hello! Tech-Recipes is using DISQUS, a powerful comment system, to manage its comments. Learn more.

Community Page

Tech-Recipes

Cookbook of Tech Tutorials
Jump to original thread »
Author

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

Started by qdideas · 9 months ago

No excerpt available. Jump to website »

3 comments

  • Very helpful! Thanks!
  • ... 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
  • Extremely handy script! exactly what I was looking for. Saved a lot of time.

Add New Comment

Returning? Login