Broken Ownership Chains

• baer

  Newbie

  Points: 7

  More actions

  November 25, 2003 at 5:55 am

  #176952

  Is there a workaround for an very limited user ( can only exec stored procs which are

  owned by the dbo) that he can execute these procedures even they are referencing objects

  which are not owned by the dbo without having to grant explicitly these rights?

  I have code in the form of URL and all these

  URL are mapped with a virtual directory on the IIS. After having changed the security settings from not using sa on the virtual directory to a limited user, I would either have to change the URL's including the owner and changing ownership of procedures as well to the effective ownership of database objects ( homogenous ownerhip) or having to

  grant all objects being referenced by the accessed storedprocedure.

  Any hint very appreciated.

  Dominik Baer

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  November 25, 2003 at 6:00 am

  #483523

  http://www.sqlservercentral.com/columnists/awarren/worstpracticesobjectsnotownedbydbo.asp and the following discussion might help

  Frank

  http://www.insidesql.de

  http://www.familienzirkus.de

  Edited by - Frank kalis on 11/25/2003 06:00:36 AM

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]