Post reply

Adding Windows Group as DBO in sql server

  • July 17, 2006 at 1:00 pm

    #67509

    Hello,

    I am trying to map a windows group to a DBO in sql server 2000..and it doesn't work.can anybody help me please..

     

    Thanks in advance..

  • July 17, 2006 at 1:27 pm

    #649656

    What do you mean by 'it doesn't work'?  You say that you've tried to map the Windows group to DBO, what did you do to attempt the setup?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • July 17, 2006 at 1:31 pm

    #649657

    I just did sp_Changedbowner 'DOMIAN/GroupName',it says login doesn't exist which is not true.

    At the same time i can add an individual windows id like mine DOMAIN/Chinn..this works.

     

    I am thinking  i can't mapp windows group to dbo...

     

    Thanks,

     

  • July 17, 2006 at 2:01 pm

    #649665

    Although it is not explicitly stated in BOL, I don't think you can change the owner to a Windows group. 

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • July 17, 2006 at 2:34 pm

    #649677

    That's what I thought.

    Thanks For The Confirmation though!

     

  • July 17, 2006 at 2:36 pm

    #649678

    BOL states user which assumes groups cannot be used. sp_ChangeDBOwner changes the actual ownership between people. If you need the Group to have DBO type rights you assign them to the database role db_owner which I bet is what you real goal is.

     

    From BOL

    login must be Microsoft® SQL Server™ login or a Microsoft Windows NT® user

Viewing 6 posts - 1 through 5 (of 5 total)

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