Re: Table Permissions

As long as (s)he is connected to SQL Server as the same user in both cases,
then that person's privileges will be the same in either case.

--
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:4315BB59-2C01-4EFE-9498-E5F0A15B1003@xxxxxxxxxxxxxxxx
If we're using Access as a Front End where the SQLServer tables are
obviously
linked, I assume that we can't have a scenario where a person has the
ability
to delete a record via the Front End *but* can't open the linked table and
delete it? In other words, the ability to delete a record is all or
nothing -
either you can or you can't regardless if you're looking at the record via a
linked table or using a Front End. (ASP pages excepted.)

"Tom Moreau" wrote:

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?



.

Relevant Pages

  • Req: Senior .Net Software Engineer required
    ... Conduct technical studies and evaluations of business area ... Ability to handle multiple projects, ... Technical Skills: ... and cardinality with a focus on MS SQL Server. ...
    (comp.os.linux.setup)
  • Re: designer wanted
    ... While the SQL Server, ... Access and Visio, may work they all have drawbacks. ... One key feature is the ability to create a database or at least tables ...
    (microsoft.public.sqlserver.server)
  • Re: How can I tell if a view has been modified?
    ... Aaron [SQL Server MVP] wrote: ... and the ability to add your own triggers to DDL events). ... Or a change manager tool to comare it to a snapshot of the production ...
    (microsoft.public.sqlserver.server)
  • Re: Order by in a INSERT INTO..SELECT
    ... But the ability isn't there. ... In SQL Server 6.5 GROUP BY implied an ORDER BY. ... There is nothing that Microsoft ... might have to rewrite it. ...
    (comp.databases.ms-sqlserver)
  • Re: Gnerating SQL scripts for database creation
    ... > In Enterprise Manager there exists the ability to have SQL scripts generated for the objects of ... I do not see the ability to have an an SQL script generated for the database ... I am using SQL Server 7, so maybe this ability does not exist ...
    (microsoft.public.sqlserver.tools)