View Single Post
  #2 (permalink)  
Old 02-02-10, 11:13
Pat Phelan Pat Phelan is offline
Resident Curmudgeon
 
Join Date: Feb 2004
Location: In front of the computer
Posts: 12,605
This is easy to do, but nearly always a bad idea. I've seen it done twice, and in both cases it caused an audit failure which cost the DBA their job within two years.

1) Backup the model database
2) Create a SQL Server login.
3) Grant that login access to every database (including model)
4) Make the users created in step 3 members of the database's db_datareader role.

-PatP
__________________
In theory, theory and practice are identical. In practice, theory and practice are unrelated.
Reply With Quote