Re: New Admin Help

From: Austin Henderson (austin@firstfleetinc.NOSPAM.com)
Date: 06/25/02 

From: "Austin Henderson" <austin@firstfleetinc.NOSPAM.com>
Date: Tue, 25 Jun 2002 10:23:16 -0500

Great thank you very much...

Have a good day.

"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:7m2hhu8umg9vkghqg860r457r80shf4vbq@4ax.com...
> Add the user to the database role db_datareader role. That
> will give them read-only access to all the tables. If you
> want to make sure they can't update anything through any
> other roles/groups they may be in, you can also add the user
> to db_denydatawriter.
>
> -Sue
>
> On Tue, 25 Jun 2002 10:15:03 -0500, "Austin Henderson"
> <austin@firstfleetinc.NOSPAM.com> wrote:
>
> >I am a Network Admin who is temporarily filling in as a DB Admin. I have
an
> >issue where we want to be able to create a user for reporting purposes
that
> >has read only access to all the tables in a db. This way if they open db
> >through access or something they cant accidentally screw something up.
Can
> >anyone tell me the security I should setup for this user? I see the
> >different roles but I am not sure which I should use.
> >
> >Thanks
> >
> >Austin Henderson
> >
>

Relevant Pages

  • Re: New Admin Help
    ... Add the user to the database role db_datareader role. ... will give them read-only access to all the tables. ... >I am a Network Admin who is temporarily filling in as a DB Admin. ... >anyone tell me the security I should setup for this user? ...
    (microsoft.public.sqlserver.security)
  • Re: New Admin Help
    ... What about the public role? ... > Add the user to the database role db_datareader role. ... > will give them read-only access to all the tables. ... >>I am a Network Admin who is temporarily filling in as a DB Admin. ...
    (microsoft.public.sqlserver.security)