Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2003
    Location
    KY
    Posts
    146

    Unanswered: Create SP denied ??

    We added a user to a database with db_datareader, db_datawriter and Create Procedure Privilages .. while creating stored procedures using dbo. prefix he gets an error


    Server: Msg 2760, Level 16, State 1, Procedure test4, Line 3
    Specified owner name 'dbo' either does not exist or you do not have permission to use it.

    What is the problem. We don't want him to create procedures with his uid as prefix .. Please help

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    You need to put him/her in the dbo_owner role...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Sep 2003
    Location
    KY
    Posts
    146

    wel

    Is it necessary ? If he is dbo he doesn't need to specify dbo. while creating objects . I don't want him to be a dbo

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    If yo uwant him to vcreate objetcs as dbo (the owner) he has to have the rights to be in the group...

    Or....

    He can develop in his own db you set up for him/her...make the dbo in that group (or not) and let them create objects without hard coding the owner...

    Then have him give you the scripts and you compile them.

    What'dya think?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •