Re: SQL Server View needs permission on underlying tabel

From: Dan Guzman (danguzman_at_nospam-earthlink.net)
Date: 07/01/04

  • Next message: Jasper Smith: "Re: Using EFS with SQL Databases" 
    Date: Thu, 1 Jul 2004 08:20:05 -0500

    > It looks like it SELECTS the VIEW and UPDATES the underlying table. Why?

    This is the behavior described in MSKB 253673.

    <Excerpt
    href="http://support.microsoft.com/default.aspx?scid=kb;en-us;253673">

    If you are using SQL Server 2000, create the view with the View_MetaData
    clause of the Create View command. For this syntax and other information,
    see the SQL Server 2000 documentation.

    </Excerpt> 

    -- 
Hope this helps.
Dan Guzman
SQL Server MVP
  • Next message: Jasper Smith: "Re: Using EFS with SQL Databases"

    Relevant Pages

    • Re: Access Front End and SQL Server 2000 Record Level Access Control
      ... > We are using Access ADP as a front end, SQL Server 2000 as a back end. ... but they cannot see clients located in the Northern Region. ... > Access allows users direct access to the underlying table. ... > tblCustomers into smaller, separate tables based on group access). ...
      (microsoft.public.sqlserver.programming)
    • ADP ideosyncrocies
      ... I have a form that is based on a view on SQL server. ... by ADP actually updates the underlying table that makes up the view. ... without actually causing the underlying data to be deleted. ... is like semibound control. ...
      (microsoft.public.access.adp.sqlserver)
    • SQL 2005 sp_attach_db fails with OS Error 5 Access is denied
      ... I have a problem that seems to be similar to the issue fixed in MSKB ... We are an ISV and our application uses a separate reports database fro ... We have one large customer who is running two instances of SQL Server ... One of these instances is used for a Training environment ...
      (microsoft.public.sqlserver)
    • SQL 2005 sp_attachdb fails with OS Error 5 Access is denied
      ... I have a problem that seems to be similar to the issue fixed in MSKB ... We are an ISV and our application uses a separate reports database fro ... We have one large customer who is running two instances of SQL Server ... One of these instances is used for a Training environment ...
      (microsoft.public.sqlserver.security)
    • Re: Tables Views Functions
      ... You can deny permissions to underlying tables and use stored ... SQL Server books online. ... How to Return Values from SQL Stored Procedures ...
      (microsoft.public.sqlserver.security)
    • Quantcast