Re: Changing login for dbo object (SQL Server 2000)

Your welcome Randall - thanks for posting back!

-Sue

On Wed, 17 May 2006 15:05:12 -0500, "Randall Arnold"
<randall.nospam.arnold@xxxxxxxxxxxxxxxx> wrote:

Worked like an absolute charm! Exactly what I needed! Thanks again.

Randall

"Sue Hoegemeier" <Sue_H@xxxxxxxxxxxxx> wrote in message
news:jl9k62p4ipgkbppvhglaqlbkgsnpt745fo@xxxxxxxxxx
It sound like what you are looking for is sp_changedbowner.
In Query Analyzer, change your database context to the
database you are having problems with and execute:
sp_changedbowner 'sa'

-Sue

On Tue, 16 May 2006 11:27:25 -0500, "Randall Arnold"
<randall.nospam.arnold@xxxxxxxxxxxxxxxx> wrote:

I've got a SQL Server 2000 database (ASOQA) that has the dbo User linked
to my Windows-based domain login. This has been causing me problems when
trying to add permissions to my account; I get an error that I can't make
any changes to the dbo object.

The fix, as I understand it, is to change the dbo User to use the sa login
and add another administrative User for my Windows-based login. I note
that a companion database on the same server is setup that way and I have
no problems with assigning roles on that one. I was directed to use
sp_change_users_login but that also produces errors stating that the dbo
object is invalid for the User parameter.

Basically, here's what I see now for users in Enterprise Manager on ASOQA:

Name Login Name
dbo noe\ranarnol *
dev dev
reportuser reportuser
(etc)

Here's how the other database is setup, and how I want ASOQA done:

Name Login Name
dbo sa *
dev dev
ranarnol noe\ranarnol *
reportuser reportuser
(etc)

noe\ranarnol is my usual login. Any ideas how I go about accomplishing
this?

Thanks,

Randall Arnold



.

Relevant Pages

  • Re: Changing login for dbo object (SQL Server 2000)
    ... change your database context to the ... to my Windows-based domain login. ... The fix, as I understand it, is to change the dbo User to use the sa login ...
    (microsoft.public.sqlserver.security)
  • Re: Changing login for dbo object (SQL Server 2000)
    ... change your database context to the ... The fix, as I understand it, is to change the dbo User to use the sa login ...
    (microsoft.public.sqlserver.security)
  • Re: PDO: Switch database user without reopening connection
    ... At the bare minimum there will be a login user who only has ... modifications to the database as well (editors get update permission, ... As database connections are expensive to ... a certain visitor in the Session, and use that value to start the right ...
    (comp.lang.php)
  • Re: PDO: Switch database user without reopening connection
    ... At the bare minimum there will be a login user who only has ... the postgres user they are logged in as to one that can make ... modifications to the database as well (editors get update permission, ... As database connections are expensive to ...
    (comp.lang.php)
  • RE: How to allow users to change their password?
    ... be set up to provide the Security dialog window for password changes. ... I'll have to login using their login ... > name/password first. ... See http://www.QBuilt.com for all your database needs. ...
    (microsoft.public.access.security)