Re: database ownership

From: Keith Kratochvil (sqlguy.back2u_at_comcast.net)
Date: 08/10/04 

Date: Tue, 10 Aug 2004 11:36:26 -0500

Read up on sp_changeobjectowner within Books Online. 

-- 
Keith
"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 name ... How do I change the ownership of these stored procedures to dbo ...
    (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)