Re: drop a database user. assign objects to dbo.

Hi

What version are you using?
In SQL 2005, you can avoid this problem by creating objects in a schema that
isn't tied to a particular user. If the user leaves, the objects stay in the
same schema and references to the objects don't need to change.

In SQL 2000, you can use the procedure sp_changeobjectowner, but it must be
run for each object.

--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com


"light_wt" <lightwt@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:018A9F91-B52A-4113-A5C1-4ABA22D34516@xxxxxxxxxxxxxxxx
hi,

i have an admin no longer with the company. He created many objects in
the
past.

i need to delete his user id from the database. the ownership after
delete
will be dbo.

what do i really need to do to get objects belong to dbo after the delete?

thanks.


.

Relevant Pages

  • Re: Access 2007, SQL 2000
    ... Since users are not dbo, and SQL 2000 used the user name as the schema identifier, you have to make sure that every reference to a SQL Server object is fully qualified with the dbo. ... Normally a user should not be able to create any new objects in the db, but if they do, those new objects will be in the userName schema, not the dbo schema, assuming the user is not a db owner. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: exporting into a SQL Server schema
    ... inside of the schema. ... The thing that's most confusing is that the dbo schema isn't ... take a look at the way the objects in the AdventureWorks database are ... It turns out that I'm moving some tables to a web hosted solution with sql ...
    (microsoft.public.access.externaldata)
  • Re: Please help with deleting a user.
    ... it says that it can not alter "dbo" schema. ... the login is the owner of a database. ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.security)
  • Re: Please help with deleting a user.
    ... it says that it can not alter "dbo" schema. ... the login is the owner of a database. ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.security)
  • SQL Adapter Disassembling Result Sets & Dynamic Parameters
    ... properties of the schema returned in my orchestration. ... Also after processing all the records returned by SQL adapter in my ... from the toolbox drag an xml disassembler ...
    (microsoft.public.biztalk.general)