11-03-2014 04:58 PM
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
11-04-2014 07:16 AM
Take a look at the batch-tools.
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:AS.IdentityGroups")'