BookmarkSubscribeRSS Feed
FB
Calcite | Level 5 FB
Calcite | Level 5

Hi to everybody,

   my company just deployed a SAS Visual Analytics 6.4 installation for a customer on two environments: a development/test environment and a production environment.

We developed a set of reports that use several LASR tables as source, and on each one of these tables we had to implement conditional grants as each user group has to have access only to a portion of data (i.e. row-level security).

We ended with a lot of security policies that are quite complex. These rules were implemented manually and are now deployed only on the test environment; now we need to replicate them on the production environment.

What we would like to know is if there is some way to automate the creation of the authorization policies on the LASR tables without the need to build them manually.

Moreover in the future these rules will be managed directly by the customer so we would like to implement a process that limits what the customer will have to do manually.

Thanks in advance

1 REPLY 1
Allan_dk
Quartz | Level 8

Take a look at the batch-tools.

SAS(R) 9.4 Intelligence Platform: Security Administration Guide, Second Edition


The you are able to use commands like this


./sas-set-metadata-access -host servername -port 8561 -user USERNAME -password PASSWORD "Table" -grant "SalesUsers":Read -condition '("rbs-"|| departmentname) IN ("SUB::SAS.IdentityGroups")' 

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 954 views
  • 0 likes
  • 2 in conversation