Re: Read only Permission and possibility to make views

From: oj (nospam_ojngo@home.com)
Date: 05/15/02 

From: "oj" <nospam_ojngo@home.com>
Date: Wed, 15 May 2002 02:40:37 -0700

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

Relevant Pages

  • Re: A question from a newbie
    ... Add the user to the db_datareader fixed database role. ... I support the Professional Association for SQL Server ... > Can somebody tell me the correct syntax if I want to grant SELECT ...
    (microsoft.public.sqlserver.security)
  • SQL2KSP4 sp_addalias and db_accessadmin
    ... A Member of the db_accessadmin Fixed Database Role Can Create an Alias ... for the dbo Special User" ... SQL Server 2000 Std Edition SP4 Japanese ...
    (microsoft.public.sqlserver.security)
  • Re: giving a user the ability to add logins and users to a database
    ... Add their login to the securityadmin fixed server role and to the ... db_accessadmin fixed database role. ... Columnist, SQL Server Professional ...
    (microsoft.public.sqlserver.security)
  • Re: Please help me with this query...thanks
    ... If you have pivoting with sql server on your mind ... perhaps you would like to check out the RAC utility for S2k. ...
    (microsoft.public.sqlserver.programming)
  • Re: cross tab query from Access
    ... the RAC utility for Sql Server:) ... RAC is similar in concept to Access crosstab ... RAC is system of server stored procedures and functions. ...
    (microsoft.public.sqlserver.programming)