Re: sql server role (read only accnt for a user)

From: Uri Dimant (urid_at_iscar.co.il)
Date: 09/19/05 

Date: Mon, 19 Sep 2005 14:06:19 +0300

Hi
Add him/her to the db_datareader fixed database role

"pleo" <pleo_el@hotmail.com> wrote in message
news:OAM4$fQvFHA.3452@TK2MSFTNGP14.phx.gbl...
>A user just wants to connect current sql database for query. No need to
>modify anything or admin. What sql server accnt role should I create for
>this user? Can I do that and please provide the steps. Thanks a lot
>

Relevant Pages

  • Creating a custom field in Project Server
    ... integer associated to a "bug" (for use with a bug-tracking application). ... this field added to one of the MS Project tables in the actual SQL Database? ... If you don't modify those tables, ...
    (microsoft.public.project)
  • Re: how to give a user permission to modify a view definition
    ... I think the user should be a member db_owner fixed database role. ... > We need to give a user a permission to modify the definition of a single ... > view in an SQL Server 2000 database. ...
    (microsoft.public.sqlserver.security)
  • Re: Creating a custom field in Project Server
    ... the number fields in Project are present in the SQL database. ... Modify or develop a table to accept the data. ... For project information and macro examples visit ...
    (microsoft.public.project)
  • Re: Modify Linked SQL table in Acess via VBA code
    ... with tables linked with a DSN-less connection. ... I need to modify one of the linked tables via code (I don't have direct ... since I can't modify a linked table to a SQL database with the ...
    (microsoft.public.access.modulesdaovba)
  • Re: Modify Linked SQL table in Acess via VBA code
    ... Destination is into the linked SQL table via ODBC ... I need to modify one of the linked tables via code (I don't have direct ... since I can't modify a linked table to a SQL database with the ... connection string definition as when I link the table to modify the ...
    (microsoft.public.access.modulesdaovba)