Re: Ownership Chain Issue

From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 11/30/04

  • Next message: Scott Shearer: "Re: Ownership Chain Issue" 
    Date: Mon, 29 Nov 2004 22:14:47 -0600

    Some tools/APIs require that you create the view with the VIEW_METADATA
    option. Otherwise, the base tables are accessed directly rather than via
    the view. You can use a Profiler trace to see if this is the case. 

    -- 
Hope this helps.
Dan Guzman
SQL Server MVP
"Scott Shearer" <ScottShearer@discussions.microsoft.com> wrote in message 
news:B12E2447-6AAD-4722-B53C-EC84517FD80E@microsoft.com...
> Here is the situation:
> I create a database - I am dbo.  In this database I have 1 table and 1
> updateable view.  dbo shows as the owner of both the table and the view. 
> I
> create a new database user and do not add them to any database or server
> roles.  I grant the new user select, update, insert and delete permissions 
> on
> the view.
>
> The user can view all data through the view, however, they cannot add or
> update.  When they attempt to add or update an error is generated 
> indicating
> that they do not have insert permissions on the table (for an add) or that
> they do not have select and update persissions on the table (for an 
> update).
>
> My understanding is that since I have an unbroken ownership chain that SQL
> Server should not even be checking the permissions on the table.
>
> What am I missing?
  • Next message: Scott Shearer: "Re: Ownership Chain Issue"

    Relevant Pages

    • Copy database user
      ... How do I copy a database user with the permissions he has ... from one server to another server ... (production). ...
      (microsoft.public.sqlserver.security)
    • RE: Windows 2003 Server - Everyone Group
      ... this folder only accessable by the users in the "special" group. ... Configure User and Group Access on an Intranet in Windows Server ... NTFS files system permissions control ... group that you want to set permissions for, click Check Names to verify the ...
      (microsoft.public.win2000.networking)
    • Fail DBD::Mysql 4.003 installation
      ... This test requires a running server and write permissions. ... permissions, then retry. ... Failed 9/9 tests, 0.00% okay ...
      (perl.dbi.users)
    • Re: Virtual Directory - Permission Denied with fso CopyFile
      ... TestUser (normal user account with same credentials on all machines). ... I created a share on a remote server. ... reviewing it's sharing permissions and security tab permissions "everyone" ... "directory security" tab on the vdir and selecting, edit, edit and manually ...
      (microsoft.public.inetserver.iis)
    • RE: SBS 2003 Outoging Fax Problem w/Error 32028 (Cannot send - fatal error)
      ... 1.Reduce the baud rate of the incoming fax modem and see how it goes. ... Click Permissions and verify that the user attempting to fax has at ... 3.If you have configured the fax client on the Windows XP computer ... On the "Additional Server Types" page, ...
      (microsoft.public.windows.server.sbs)