Post reply

how to script permissions for stored procedures

  • January 11, 2006 at 8:27 pm

    #111292

    all,

    In sql 2005 I don't see the option to script the object-level permissions for sps, like we can in sql 2000. Can someone point out how this can be done?

     

    Thanks in advance

  • January 16, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • January 16, 2006 at 12:40 pm

    #614986

    This is very different from 2000 (why should this be the exception :mad

    Open up Object Explorer, right click on the database that has the stored procedures you're interested in and choose Tasks then Generate Scripts. A wizard will start and on the second screen you will see all the scripting options (one is for object level permissions). On the third screen, you'll can choose which objects you want so this is where you would choose stored procedures.

    Hope that helps. It's very frustrating trying to find what you know must exist somewhere!

    MG

    "There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
    Tony Hoare

    "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

  • March 9, 2006 at 2:31 pm

    #625809

    Sort of related to this...

    I would like to script *just* the object-level permissions without the CREATE or DROP statements (like I could in enterprise manager by unchecking the checkboxes for generate CREATE and DROP statements). You don't seem to be able to do this in the management studio script generation wizard.

    Am I missing an option?

    Thanks!

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

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