Re: Read only Permission and possibility to make views

From: news@news.com
Date: 02/19/03 

From: <news@news.com>
Date: Tue, 18 Feb 2003 20:46:45 -0800

ddl admin comes with some baggage, a more correct solution would be to grant
create view to the user and place it in the db_datareader role

"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@reproms.si> wrote in
message news:ewcBJKA$BHA.2296@tkmsftngp05...
> Hi!
>
> You can add them to the db_ddladmin role, so they can create objects in
db.
>
> --
> Dejan Sarka, SQL Server MVP
> FAQ from Neil & others at: http://www.sqlserverfaq.com
> Please reply only to the newsgroups.
> PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
>
> "Camille" <camillegomes@yahoo.com> wrote in message
> news:326701c1fbf5$22b3e9e0$9ee62ecf@tkmsftngxa05...
> > Hi Oj.
> >
> > Yes, I had assign the db_Datareader for the user...but in
> > this way it can' t make views in my access project neither
> > in my SQLServer.
> > I'd like to have also this possibility to make views and
> > reports in my access project... but without change the
> > dates inside of my database sql.
> >
> > Thanks again
> > Camille
> > >-----Original Message-----
> > >if you assign the sqllogin to db_datareader fixed
> > database role, the user
> > >can only read the data.
> > >
> > >--
> > >-oj
> > >Rac v2.0 and ObjectScriptr @ new home
> > >http://www.rac4sql.net
> > >Favorite FAPs @
> > >http://vyaskn.tripod.com
> > >
> > >
> > >
> > >"Camille" <camillegomes@yahoo.com> wrote in message
> > >news:366b01c1fbef$85f5ab70$b1e62ecf@tkmsftngxa04...
> > >> Hello
> > >>
> > >> I am working with access 2000 and SQL 7.0.
> > >> In my application I made an Access Project connecting
> > with
> > >> my tables in SQL Server.
> > >> I worked with permissions in SQL server to grant access
> > >> for some groups and readonly access for some others
> > >> My doubt is this: I want that the user have the
> > >> possibility to read the dates, make and change views and
> > >> reports in my accessproject, but not modify the data in
> > my
> > >> SQLServerDatabase.
> > >>
> > >> How can i do that?
> > >> Thanks a lot
> > >> Camille
> > >
> > >
> > >.
> > >
>
>