Post reply

removing builtin\Administrators group having dbo on all dbs

  • June 8, 2006 at 9:44 am

    #113318

    Hi guys,

    I have builtin\Administrators groups is added as dbo to all of my databases.I need to remove it.The sql server is running under it's own account and all dbs are owned by sa.

    Any help?

    Thanks.

     

  • June 8, 2006 at 9:53 am

    #642581

    guys...nevermind..

    it was pretty simple but sometime we forget as we don't use frequently.

    Thanks.

  • June 9, 2006 at 7:54 am

    #642796

    Okay, for those of us who use this site to learn about SQL server, how did you do it?

    Steve Eckhart

  • June 9, 2006 at 10:39 am

    #642854

    use sp_revokelogin

    hth

     

  • June 19, 2006 at 9:01 am

    #644632

    You might consider removing the SysAdmin privilege from builtin\Administrators group before getting rid of it away in case something is using the group unaware (like backup software, etc.).  Then you could re-enable SysAdmin privilege until the appropriate individual user is added as a login.  If no problems after a while (a month maybe), you can then blow away builtin\Administrators.

    Steve

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

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