Re: Change dbo

Tom - Sorry, I do not know what you mean about multi-post. This is the only
place I have posted this request for help and I see no other offered
solution. Perhaps you could explain?

I have posted other issues, but this is the only one for this issue.


"Tom Moreau" <tom@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:Ot3vMvmlIHA.5396@xxxxxxxxxxxxxxxxxxxxxxx
Please do not multi-post. This was answered in another ng today.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"GoodwinM" <mitchgoodwin@xxxxxxxxxxx> wrote in message
news:eMMzStmlIHA.5956@xxxxxxxxxxxxxxxxxxxxxxx
I am not a SQL kind of person, but sure hope someone here is:

I have a database where a user is defined as the dbo on a database. I do
not
want this user defined as such. I assume this was generated during
creation
of the database.

Is there a way to remove this user from being dbo on a database, or
changing
the dbo schema to another user? I tried using SQL Server Manger and just
unchecking the box, but of course this fails.




.

Relevant Pages

  • Re: Using SQl to store aspx pages and memory problems
    ... I've seen classic ASP applications design this way that work ... database isn't some sort of magic pixie dust that solves all problems. ... > the memory increases - the slowness of the request could be dealt with by ... >> takes to get the page from SQL Server. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Confused about dbo
    ... Jasper Smith (SQL Server MVP) ... > database within a SQL Server instance. ... > There are several ways you could have the username dbo. ... > the true owner of the database. ...
    (microsoft.public.sqlserver.security)
  • Re: Change dbo
    ... I have a database where a user is defined as the dbo on a database. ... I tried using SQL Server Manger ... The login for this person maps to dbo. ...
    (microsoft.public.sqlserver.security)
  • Re: System Administrator Implied Permissions
    ... mapped to the 'dbo' user are members of the public and db_owner roles. ... Permissions are not checked for sysadmin role members so all other role ... > database role need to be assigned to any sysadmin role? ... >>> SQL Server initially creates the 'sa' user. ...
    (microsoft.public.sqlserver.security)
  • Re: Delegate Power of God to only 1 database - How?
    ... Guess I'll have to look more closely at the permissions ... >I support the Professional Association for SQL Server ... >> permissions to only that database which can be assigned ... >>>Exactly what is this 'dBO' role you are referring to? ...
    (microsoft.public.sqlserver.security)