DISQUS

Craig · 1 year ago

Very helpful! Thanks!
Marc Jellinek · 10 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 · 9 months ago

Extremely handy script! exactly what I was looking for. Saved a lot of time.
SQLPaul · 2 weeks ago

Perfect! only wanted user to access tables and not views so adding to the db_datareader role was not an option. Thanks!