Re: change ownership of objects

Hello,

Fiirst of all change the password for his account to a one with special
charecters, so as no one can access. After that you could use
sp_changeobjectowner system proc to change the owner of all object from that
user to DBO. take
alook into sp_changeobjectowner in books online..Once you completed the
object owner to DBO you could drop the user and
login associated.

Thanks
Hari

"berwiki" <steveberwick@xxxxxxxxx> wrote in message
news:1171656219.472511.150980@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
A co-worker recently quit the company, and all of his stored
procedures and DTS packages are apparently under his name. Is there
any way to change his account to another (ie administrator or SA)??

I am afraid to delete his account in fear all the stored procedures
will be lost. (we have backups, but ... ugh)


(running mssql server 2000)



.

Relevant Pages

  • Re: Convert SQL Account to Windows Accounts + EXEC on ALL SPs
    ... I have an SQL Server 2000 Database that has an "SQL Account" that has ... execute permission on all Stored procedures. ... This one account is used by "all workstations". ... I want to fix this and use Windows Accounts, and get rid of that SQL ...
    (comp.databases.ms-sqlserver)
  • Newbie: Restrict user account access to stored procedures
    ... to add/edit/delete tables and stored procedures, and a dedicated user ... account for my website. ... I am manipulating all the data through stored procedures and would like to ... Is it possible to restrict a user account to the stored procedures only? ...
    (microsoft.public.sqlserver.security)
  • Re: Stored Procs in SQL 2005
    ... How do i give execute privileges on stored procedures to an account? ... Arne Garvander ... Professional Data Dude ...
    (microsoft.public.sqlserver.security)
  • Re: Display ADO recordset
    ... BillyRogers wrote: ... to be passed to the stored procedures based on account numbers ... entered into text boxes on the form. ...
    (microsoft.public.access.modulesdaovba)
  • Re: ASP.net insists on using dbo. to call aspnet_* stored procedures
    ... No. mysql_login is one account and the dbo is another account, ... SQL Server 2000 developer in same machine. ... connection string is setup to use the sql login assigned to the ...
    (microsoft.public.dotnet.framework.aspnet)