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

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

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
  • 899 views
  • 0 likes
  • 2 in conversation