locked
Can set an Entity as not delete? RRS feed

  • Question

  • Is it possible to set an entity is update but can't add/delete?

    I want to control adding/deleting members in SSIS from another source system, but only allow users to change certain attributes.

    Thanks,

    md

    Sunday, October 4, 2015 10:01 AM

Answers

  • I believe this is not supported now, and it will have more granular security control (read, create, update, delete) in SQL2016. I believe that will support my needs.

    • Marked as answer by md4fun Friday, October 9, 2015 1:30 AM
    Friday, October 9, 2015 1:30 AM

All replies

  • Could you try set entity as ReadOnly and set each attribtue as update?
    Thursday, October 8, 2015 12:24 AM
  • Thanks for suggestion. Unfortunately, it is not working. 2 things tested:

    1. Set the entity as readonly. Can't change and delete but still can add from Excel add-in.
    2. Set entity as ReadOnly and set Name attribute as Update (see below image). The entire entity become updatable, can change, add and delete.

    Thursday, October 8, 2015 5:17 AM
  • I believe this is not supported now, and it will have more granular security control (read, create, update, delete) in SQL2016. I believe that will support my needs.

    • Marked as answer by md4fun Friday, October 9, 2015 1:30 AM
    Friday, October 9, 2015 1:30 AM