Post reply

GRANT CONTROL versus object ownership

  • October 26, 2007 at 12:55 pm

    #176606

    I'm having trouble coming up with a scenario, other than taking advantage of ownership chaining, where I would want to change the ownership of an object, like a table, so that a user different than the schema owner owns that object.

    .

    For example, in AdventureWorks, dbo owns the HumanResources schema, which contains a table called Department. dbo implicitly owns the Department table because it is contained in the HumanResources schema. Using ALTER AUTHORIZATION I can change ownership of the HumanResources.Department table to a different user, testuser.

    And if such a scenario does exist, wouldn't GRANT CONTROL be a viable alternative to changing ownership?

  • December 2, 2007 at 1:19 pm

    #756309

    Not sure you would want this, though it's possible that you have different developers that have rights to create objects in the schema. In that case, the object owner and schema owner are different.

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply