locked
Security and stored procedures RRS feed

  • Question

  • Hello,

    Quick question.  Our developers have alter permission in DEV to all the stored procedures.  I did dynamic SQL to make the grants.  Today, one came up with no grant.  Does the sp lose its grants when recompiled or recreated?  Just wondering how this happened.

    Dianne


    Dianne

    Tuesday, March 26, 2019 3:27 PM

Answers

  • It loses its rights when recreated. You should be able to right click on the database, select reports and schema changes history and find a historical record of the changes and who did what when.
    • Marked as answer by DianneScott Tuesday, March 26, 2019 3:53 PM
    Tuesday, March 26, 2019 3:51 PM

All replies

  • It loses its rights when recreated. You should be able to right click on the database, select reports and schema changes history and find a historical record of the changes and who did what when.
    • Marked as answer by DianneScott Tuesday, March 26, 2019 3:53 PM
    Tuesday, March 26, 2019 3:51 PM
  • Perfecto!  Thank you!

    Dianne

    Tuesday, March 26, 2019 3:55 PM