User rights problem

From: Gopinath M (GopinathM_at_discussions.microsoft.com)
Date: 07/21/05 

Date: Thu, 21 Jul 2005 03:40:03 -0700

Hi,
   I'm have a user called "developer" with rights create procedure,
db_datareader and db_datawrite. When i try to create an sp with owner as dbo
i'm getting the following error

"Specified owner name 'dbo' either does not exist or you do not have
permission to use it."

here is the sample script which i'm using to create the procedure

CREATE PROCEDURE dbo.pGetPatientList
AS
BEGIN
       SELECT Name, Age FROM Patient
END.

     I would like to create an sp with owner dbo. Can you please tell me the
rights which i should give to the "developer" login for donig so. I cant
grant db_owner rights to the "developer" login(this is to restrict the user
from modifying schema of user tables and contraints).

Regards,
Gopinath

Relevant Pages

  • Re: User rights problem
    ... You cant give permission to developer to create a stored procedure under the ... db_owner rights and execute the below command to change the owner to dbo. ... This will make the object owner to dbo. ...
    (microsoft.public.sqlserver.security)
  • RE: View Designer Role and Security
    ... Have you tried making the user a member of the db_owner role and when he ... This will make the dbo the owner of the view so you should not have to give ... This posting is provided "as is" with no warranties and confers no rights. ...
    (microsoft.public.sqlserver.security)
  • Re: High strength fibers for high pressure tubes.
    ... ***{In such a case, properly, there is no one to sue. ... will be sufficient to indicate denial of permission by the owner ... > Doesn't matter unless I signed away some of my rights when I moved in. ... neutral arbiter, rather than point a gun at you and take the wallet by ...
    (sci.physics)
  • Re: FEAR the new weapon
    ... duly acknowledged and if copy rights exist they should be respected. ... Do I need permission from the copyright owner beforehand? ... >> Copyright is a form of protection provided by the laws of the United ... >> sound recording is not the same as a phonorecord. ...
    (microsoft.public.windowsxp.moviemaker)
  • Re: Copyright & Fair Use
    ... duly acknowledged and if copy rights exist they should be respected. ... Do I need permission from the copyright owner beforehand? ... >> Copyright is a form of protection provided by the laws of the United ... >> sound recording is not the same as a phonorecord. ...
    (microsoft.public.windowsxp.moviemaker)