topic Re: How to prevent end users connecting to CAS from creating any new CASLIB? in Administration and Deployment

How to prevent end users connecting to CAS from creating any new CASLIB?

EyalGonen — Sun, 24 Dec 2023 07:52:02 GMT

Hi experts,

How can I prevent CAS users from any client (SAS Studio, Python, etc.) from creating new CASLIBs and force them to use only existing globally defined CASLIBs?

Thanks

Re: How to prevent end users connecting to CAS from creating any new CASLIB?

Patrick — Sun, 24 Dec 2023 09:58:20 GMT

https://documentation.sas.com/doc/en/pgmsascdc/v_044/casref/n0kizq68ojk7vzn1fh3c9eg3jl33.htm

Adjust Caslib Management Privileges

Re: How to prevent end users connecting to CAS from creating any new CASLIB?

EyalGonen — Sun, 24 Dec 2023 11:05:57 GMT

Thanks @Patrick

Do you know if I disallow Authenticated Users from creating Session CASLIBs (which they are allowed by default) will that have a negative impact on SAS Visual Analytics app?

I do not want them to create any caslib when they use SAS Studio or Python (SWAT) client but do not want that to cause issues in SAS VA.

This is what I currently have set:

Re: How to prevent end users connecting to CAS from creating any new CASLIB?

Patrick — Sun, 24 Dec 2023 22:48:46 GMT

@EyalGonen

I don't know more than what's in the docu. Why don't you just try it out?

Re: How to prevent end users connecting to CAS from creating any new CASLIB?

SASKiwi — Sun, 24 Dec 2023 23:17:23 GMT

@EyalGonen - I would be very surprised if SAS VA on Viya used anything other than global CASLIBs, purely from a performance point of view. Data needs to be already loaded in memory to provide good VA report performance.

Re: How to prevent end users connecting to CAS from creating any new CASLIB?

Patrick — Mon, 25 Dec 2023 02:38:58 GMT

@SASKiwi wrote:

@EyalGonen - I would be very surprised if SAS VA on Viya used anything other than global CASLIBs, purely from a performance point of view. Data needs to be already loaded in memory to provide good VA report performance.

@SASKiwi That's mostly also my assumption. In regards of data being loaded: With more recent Viya versions one can define tables as to get loaded if requested but not already loaded. This removes all these challenges with "reload on restart" but avoids loading tables that don't really get used anymore. The first person requesting the data has of course to wait until the data is loaded - but that's imho much better than a report failing.

Unfortunately this functionality is only available for VA/VS - but I guess that's also where it's most relevant.