data-masking | Data desensitization

I would like to use dplyr::arrange to sort the rows of a data frame based on values in specific columns. I want to choose the columns based on position rather than column name, as the column names will vary based on the input. I have tried to adapt the suggestions for dplyr::select found here (dplyr: select columns by position in NSE), but my code just returns the original data frame with no changes. Here is my data frame and the code I've used to sort it:

I am trying to build a page where it returns table for the logged in user. And then you can use the filter to look at other users records .

User = USERPRINCIPALNAME()

I am having problems filtering the table for the logged in user . Without using row level security with data model changes like below . Is there a way for the Power BI table to return data just for the logged in user ? No SSAS involved.

https://medium.com/@barrasa8/dynamic-data-masking-in-powerbi-based-on-rls-927eb6a34e5d**strong text**

The data model is a FACT table linked to a USER dimension. In the User Dimension , there is an email address which is what the USERPRINCIPALNAME() resolves to.

I thought about a DAX summary table with summarise and may try that later . Then 2 buttons on the page , one to show current logged in user and the other button just gives you details about all other users data and work with all the filters on the page .

So basic want is

Logged In User : X

Table - Col 1 , 2 ,3 .... ( Filtered for User x only by default )

Then I would like a way for the logged in user then to see others user data easily.

I am currently creating a Shiny app which should build plots according to user input. The user can choose between histograms, density and scatter plots, which variables to depict and what titles/labels to display. Since this is Shiny, I tried to follow the instructions given in https://mastering-shiny.org/action-tidy.html which explain how to use tidy evaluation in this context.

I create a basic plot object with ggplot(..., aes(rlang::.data[[]])) and add the geoms later on. Unfortunately, I then encounter the following error message on trying to display the plot:

we need to expose an internal API to vendor, however for development we need to mask the data the internal API replies, looking for a similar feature with apigee (https://docs.apigee.com/api-platform/security/data-masking), can this doable via APIM?

Is there any feature in the BigQuery roadmap to support dynamic data masking? For example, displaying masked data based on the user's roles. I have explored DLP which helps in storing masked data in BigQuery, but with that approach, one will have to create two versions of the same table masked and unmasked. Please refer to the following link as an example to get additional context to my ask. (Example Link)

Long time reader, first time posting so apologies if anything doesn't confirm to the correct way.

I currently built a SaaS platform, with a MySQL database containing PPI. I want to expand the team and require them to access the database. However; theres' way too much PPI data to allow a new remote hire access to it all.

I came across Microsoft SQL Server's Dynamic Data Masking function which was perfect until I realised it isn't available in MySQL. I can't find any similar function, does one exist? and if not any suggestions as to how I could achieve something similar to granting access whilst protecting my data

Thanks

I would like to generate the data by given regex pattern in SQL Server. Is there any possibility to do? Say, I have pattern as below and I would like to generate data as follow:

The idea behind the concept is SQL STATIC DATA MASKING (which was removed in current feature). Our client wants to mask the production data in test database. We don't have SQL STATIC DATA MASKING feature with sql now but we have patterns to mask the column, so what I am thinking is, with these pattern we can run the update query.

I have a Microsoft SQL Server with data that needs to be protected (certain sensitive columns of some tables) and an application that queries that database like this:

I'm implementing a QR code generation algorithm as explained on thonky.com and I'm trying to understand one of the cases:

As stated on this page, after getting the percentage of the dark modules out of the whole code, I should take the two nearest multiples of five (for example 45 and 50 for 48%), but what if the percentage is a multiple of 5? for example 45.0? what numbers should be taken? 45? 40 and 50? 45 and 40? 45 and 50? something totally different? I couldn't find any answer to that anywhere...

Thank you very much in advance for the help!