Re: dbo question
From: Steen Persson (SPE_at_REMOVEdatea.dk)
Date: 01/18/05
- Next message: Mark Allison: "Re: Ask Index creation principle"
- Previous message: Dejan Sarka: "Re: Changing a Primary Key to Foreign Key"
- In reply to: Wayne Snyder: "Re: dbo question"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 18 Jan 2005 09:15:23 +0100
Thanks Wayne,
I investigated it a little bit further, and I think I found out what
confused me. When I look at the dbo user for a database in EM, it shows no
Login Name. If I then look at the same db in QA (sp_helpdb) it shows the
owner ok.
The cases where EM doesn't show a login name, seems to be the ones where the
dbo isn't mapped to a login name that has been created as a login in SQL
but is a user that's member of the SystemAdministrator role (and/or in the
local admin groups on the server). This might be obvious and clear for
others, but it confused me a little bit...;-).
Thanks for your inputs.
Regards
Steen
Wayne Snyder wrote:
> dbo is always mapped to something. It is safe to map all of them to
> sa or some other login you expect will always exist.... I use either
> sa or a trusted login so moving databases arouns isn't quite so much
> trouble.
>
>
> "Steen Persson" <SPE@REMOVEdatea.dk> wrote in message
> news:u36YSpI$EHA.612@TK2MSFTNGP09.phx.gbl...
>> Hi Mark
>>
>> The reason for removing this specific dbo user, is because we are
>> trying to "clean up" our SQL server installations. We have 8 servers
>> for various applications and there haven't really been any corporate
>> guidelines for how to install them. They are therefore installed and
>> configured in different ways.
>>
>> As I understand the sp_changedbowner, it will map the username
>> spcified to the dbo role, but I'm not sure that's what I want.
>> If I look at some of the other SQLServers, it looks like no specific
>> loginname has been mapped to 'dbo'. In this case I assume that dbo
>> is the loginnames which are members of the System Administrators
>> Role on the server. I don't know if this scenario is advisable or
>> not, but would it be possible to remove the dbo mapping to a
>> specific loginname and change it to a "blank" loginname?
>>
>> /Steen
>>
>>
>> Mark Allison wrote:
>>> Hello Steen,
>>>
>>> You can use sp_changedbowner like this:
>>>
>>> use <mydb>
>>> exec sp_changedbowner 'sa'
>>>
>>> This will map the sa login to dbo user in the mydb database. Why do
>>> you want to remove the dbo user?
>>>
>>> Mark.
>>>
>>>
>>>> Hi
>>>>
>>>> I can see that in some of our databases, the user 'dbo' are mapped
>>>> to a specific loginname where in others it's not mapped to
>>>> anything. How can I change this so the 'dbo' user isn't mapped to
>>>> a specific useraccount. The reason is that I'd like to remove the
>>>> login that's set as 'dbo' for those databases.
>>>>
>>>> I've looked in BOL, but I'm not quite sure about the steps to
>>>> perform to get this fixed. I know that all members of the Sysadmin
>>>> role is mapped to 'dbo' so that's what I'd like to have rather
>>>> than mapping a specific user to the 'dbo' user.
>>>>
>>>> Since it's in our production environment is has to be changed, I'd
>>>> like to be fairly sure about the steps to do before I just go ahead
>>>> and change it...;-)
>>>>
>>>> Regards
>>>> Steen
- Next message: Mark Allison: "Re: Ask Index creation principle"
- Previous message: Dejan Sarka: "Re: Changing a Primary Key to Foreign Key"
- In reply to: Wayne Snyder: "Re: dbo question"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
