domain admin recorded as dbo

  • I am a part of the domain admin on our server that houses our sql dbases.  Any changes I make to a dbase gives a stamp of dbo.  If I am not a part of the domain admin group the name stamp that is used is my login.  How can I be a part of the domain admin group on the server and have the namestamp place my login instead of dbo.

     

    seeker54

  • As long as you are in the sysadmin role, any objects you create will automatically be dbo unless you specify an owner.  You should always specify an owner, but very few people actually do... 

    If you want objects you create to automatically be owned by your login, you should first grant your login (or a windows group that your are part of) login rights and then grant your login the appropriate rights in the database(s) in question.  Then remove the Builtin\Administrators from the sysadmin group.

    I always remove the builtin\admins from the sysadmin group as part of the install process, but if you and others have been using this to gain access, you should carefully research the security implications of doing this, particularly if this is a production system...

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/

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

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