Post reply

Problem With Changing Permissions.

  • February 15, 2005 at 6:01 am

    #60983

    HI,

    I am facing some problem with changing the permissions of some procedures in a database. These procedures are not having any permissions set. The procedures are owned by someother user, say user1. I need to give execute permission for this procedures to some other users also. I am using sa login.

    I tried the following...

    1. Change the owner of the procedure to sa

    2. Grant the permissions to other users.

    3. Set the owner back to user1.

    But what I have observed is that when I try to change the owner, it gives error message saying that the procedure could not be found (possibly because even sa is not having any permissions granted).

    Could anybody please provide any guidence to me ?

  • February 15, 2005 at 6:18 am

    #542253

    sp_changeobjectowner 'some1.object', 'sa' ???



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • February 15, 2005 at 6:40 am

    #542259

    Thanks. It worked 🙂

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply