Re: Read-Only Access

From: Hari (hari_prasad_k_at_hotmail.com)
Date: 02/25/04 

Date: Wed, 25 Feb 2004 16:06:31 +0530

Hi,

Assign DB_datareader role to the user.

sp_addrolemember 'db_datareader', 'user_name'

Thanks
Hari
MCDBA

"Wayne" <anonymous@discussions.microsoft.com> wrote in message
news:10d201c3fb88$ab5ba5a0$a501280a@phx.gbl...
> Apart from being a member of db_owner (having full
> read/write to the database) - I I need to grant a user to
> have only READ-ONLY to database with 500 tables - what do
> I do?
>
> Thks!