Re: Table Permissions

From: "Tom Moreau" <tom@xxxxxxxxxxxxxxxxxxxx>
Date: Mon, 18 Aug 2008 15:10:20 -0400

Correct. You can use the GRANT statement to do that. Now, if you want them
to have read permission on all tables and views, then you can add them to
the db_datareader role.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau

"dch3" <dch3@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F1131EEA-F4F3-4F67-87DC-06B85982242D@xxxxxxxxxxxxxxxx
I'm assuming that its possible to restrict a user to read-only access for
any
particular table in a database?

.

Follow-Ups:
- Re: Table Permissions
  - From: dch3

References:
- Table Permissions
  - From: dch3

Prev by Date: Table Permissions
Next by Date: Re: Table Permissions
Previous by thread: Table Permissions
Next by thread: Re: Table Permissions
Index(es):
- Date
- Thread

Relevant Pages

Re: code access security
... Error 1 CREATE ASSEMBLY for assembly 'GmsSqlClr' failed because assembly ... owner has EXTERNAL ACCESS ASSEMBLY permission and the database has the ... make sure the database owner is mapped to the correct login on ...
(microsoft.public.dotnet.languages.csharp)
Re: low permission cannot convert from A97 to A2000/2003
... Delete is a separate permission. ... You need open exclusive permission on the database to ... > The admin user has full privileges. ... > as we wont be importing those files from them, and the contractor will be ...
(microsoft.public.access.conversion)
Re: low permission cannot convert from A97 to A2000/2003
... Delete is a separate permission. ... You need open exclusive permission on the database to ... > The admin user has full privileges. ... > as we wont be importing those files from them, and the contractor will be ...
(microsoft.public.access.security)
Re: Windows Power User SQL
... The guest user must have connect permission in master and tempdb. ... When I run from the master database for example testing against user bill ...
(microsoft.public.sqlserver.security)
Could not Lock File error
... >I'm trying to share an access database with an entire ... >modifying this file with FULL PERMISSION on the parent ... >or not AND ONLY allowing one person to modify it's ... It's called an .LDB file, ...
(microsoft.public.access.security)