Re: database ownership

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 08/10/04 

Date: Tue, 10 Aug 2004 18:33:48 +0200

Check out sp_changeobjectowner. 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Raks" <Raks@discussions.microsoft.com> wrote in message
news:553BF42A-9184-4624-A62F-A730605CDDD0@microsoft.com...
> I have a database which has stored procedures which have an owner by the name
> of essbase.  How do I change the ownership of these stored procedures to dbo
>
> Thanks

Relevant Pages

  • Re: database ownership
    ... "Raks" wrote in message ... > I have a database which has stored procedures which have an owner by the ... How do I change the ownership of these stored procedures to ...
    (microsoft.public.sqlserver.server)
  • System Stored Procedure Permissions
    ... I have system stored procedures in a databse ... somehow instead of showing the owner as dbo and type as ... database. ...
    (microsoft.public.sqlserver.security)
  • Change Stored Procedure object owners for hundreds of objects
    ... Is there a quick way to change the owner of all the stored procedures in a ... TIA! ...
    (microsoft.public.sqlserver.programming)
  • Re: Database Model - Class, objects and interaction
    ... I was just proving stored procedures can call views. ... stuff like security and logging. ... So given 100,000 users, you would create database accounts for each? ... Part of our system's integrity was its reliability, and reliability is often assisted by simplicity. ...
    (comp.object)
  • Re: Database Model - Class, objects and interaction
    ... Stored procedures should only be used as a last resort if you cant use ... I've not said that views shouldn't be created, only that they shouldn't be exposed as the interface to the database. ... But business rules can be more complicated than simply defining overdue invoices. ...
    (comp.object)