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 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!

Submit your idea!

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