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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Read only user

Author  Topic 

iwin369
Starting Member

13 Posts

Posted - 2010-09-07 : 06:16:25
Hi All,

Can you please let me what permissions or server roles should be given to a read only user in sql server 2005

Many Thanks

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-09-07 : 08:25:29
no server roles other than public

make them db_datareader in any database you grant them read access to.
Go to Top of Page

iwin369
Starting Member

13 Posts

Posted - 2010-09-07 : 08:36:07
thanx russel
Go to Top of Page
   

- Advertisement -