Re: Two DB Owners
From: Bill Cheng (billchng_at_online.microsoft.com)
Date: Tue, 10 Jun 2003 13:11:51 GMT
I am not sure what effect you want to achieve. However, if you want to
impede Microsoft Windows NT system administrators from having system
administrator (sa) privileges in SQL Server, you may check the following
263712 INF: How to Impede Windows NT Administrators from Administering a
295034 FIX: Microsoft Search Service May Cause 100% CPU Usage if
This posting is provided "AS IS" with no warranties, and confers no rights.
Microsoft Support Engineer
| From: "Joshua A. Booker" <email@example.com>
| References: <umBQacrLDHA.2052@TK2MSFTNGP11.phx.gbl>
| Subject: Re: Two DB Owners
| Date: Mon, 9 Jun 2003 15:55:47 -0400
| Lines: 47
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
| X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
| Message-ID: <#oMqPHsLDHA.1960@TK2MSFTNGP11.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.security
| NNTP-Posting-Host: me-rockland-qs-19.mint.adelphia.net 22.214.171.124
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.security:13857
| X-Tomcat-NG: microsoft.public.sqlserver.security
| I need to add the BUILTIN\Administrators login to certain roles in a
| database. Because it's set to use the 'dbo' user in this database, I get
| the message '15405 can't use reserved user 'dbo' when I try to permit the
| role. For this reason, I'd like to remove all permissions from the admins
| group so it will not use 'dbo' user. When I remove the login it doesn't
| remove the permissions that point to user 'dbo' for this login. How do I
| permit the login to use a role if the login points to the reserved user
| "Steve Thompson" <SteveThompson@nomail.please> wrote in message
| > "Joshua A. Booker" <firstname.lastname@example.org> wrote in message
| > news:umBQacrLDHA.2052@TK2MSFTNGP11.phx.gbl...
| > > I have two dbowners in each database. I would like sa to be the only
| > > owner, but the 'BUILTIN\Administrators' login has permiaaions as user
| > 'dbo'
| > > for every database. I have dropped the 'BUILTIN\Administrators'
| > and
| > > run the sp_change_dbowner stored procedure, but somewhere permissions
| > > remain for the Administrators group. When I re-add the login, it says
| > > has been detected that this login has permissions in specific
| > databases...'
| > > Then it gives the login permissions as 'dbo' to each database. How
| > > drop all permissions for 'BUILTIN\Administrators'?
| > It's not necessary to drop all permissions for the
| > group. Once you delete that group, you effectively prevent anyone who
| > Administrative rights on your server from having sa equivalence on your
| > Server.
| > As you've discovered, you can add the 'BUILTIN\Administrators' group
| > in, that's by design.
| > Steve