Home Forums SQL Server 2005 SQL Server 2005 Security my application user asking to give access to execute a storedprocedure in any database it it possible? if so how RE: my application user asking to give access to execute a storedprocedure in any database it it possible? if so how

  • 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)