Post reply

my application user asking to give access to execute a storedprocedure in any database it it possible? if so how

  • October 5, 2012 at 3:34 am

    #282697

    Hi all

    one of my application user asking to give access to execute a storedprocedure where ever he wants to execute in any database it it possible? if so how

    wha permissions can we give inthis case ??

    i feel it by giving [ddladmin and db_owner ] in database role and setupadmin and serveradmin in server role ??

    is it possible to make a stored procedure to execute in any database ?

    Thanks
    Naga.Rohitkumar

  • October 16, 2012 at 5:51 am

    #1549490

    grant exec on "stored_proc" to "user"

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • October 16, 2012 at 4:24 pm

    #1549821

    naga.rohitkumar (10/5/2012)

    Hi all

    one of my application user asking to give access to execute a storedprocedure where ever he wants to execute in any database it it possible? if so how

    wha permissions can we give inthis case ??

    i feel it by giving [ddladmin and db_owner ] in database role and setupadmin and serveradmin in server role ??

    is it possible to make a stored procedure to execute in any database ?

    I have to ask... what does this store procedure do and why would you have a user execute it? It'll make a difference in how I answer.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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