Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rtwegab
Starting Member
1 Post |
 Posted - 2010-02-02 : 09:48:12
|
| What is the best way to go about setting up an account for Read Only access for the entire SQL instance?This would allow the user to read data from all the databases including new ones. |
|
|
dmaxj
Posting Yak Master
174 Posts |
Posted - 2010-02-02 : 14:33:38
|
| I am not sure about a READ-ONLY instance. But you can make read-only databases in an instance:ALTER DATABASE database-name SET READ_ONLY |
 |
|
|
|
|
|
how to create a Read Only instance-wide Account