Home Forums SQL Server 2008 Security (SS2K8) Granting select to all databases current and future? RE: Granting select to all databases current and future?
David Webb-CDS
SSCoach
Points: 17398
More actions
September 20, 2013 at 2:03 pm
#1652040
Haven't tried this, but you could set them up with the db_datareader role in the Model database. When Model is copied as the basis for any new database, the role definition would come along.