Dynamic - Row Level Masking.

  • Hi,

    I have looked into Dynamic Data Masking and Row Level Security, Is there any we can combine both of them?.

    Here is my requirement.

    Table contains 20 rows , i would like to mask data for 15 rows and rest of them should be left as unmasked.

    I don't want to remove data from table. Table should contain 20 rows with 15 are masked and 5 are unmasked.

    Please let me know if you any questions, Thank you for your help!

  • This sounds interesting.  It would appear that the "auto bumping" mechanism failed to bump your unanswered question.  I can't help here but I can bump the post for you by replying.

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

  • I don't think it is possible as Dynamic Data Masking  is applied to column(s) not rows.

    One thing to try is to create view that does your own masking of columns by row and use it instead of the table.

    Far away is close at hand in the images of elsewhere.
    Anon.

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

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