topic Re: How to Apply Raw Level Security in SAS Store Procedure? in SAS Programming

How to Apply Raw Level Security in SAS Store Procedure?

kaushalsolanki — Wed, 05 Feb 2020 10:41:35 GMT

Hi All,

I am looking to apply raw level security wih-in SAS Stored Procedure.

Thanks in advance.

Regards,

Kaushal

Re: How to Apply Raw Level Security in SAS Store Procedure?

Satish_Parida — Wed, 05 Feb 2020 11:22:11 GMT

Could you please elaborate.

This is to lock a dataset.
http://support.sas.com/kb/51/275.html

Password Protecting a SAS data set.
https://v8doc.sas.com/sashtml/lrcon/z0995299.htm

Re: How to Apply Raw Level Security in SAS Store Procedure?

japelin — Thu, 06 Feb 2020 00:35:54 GMT

you can use encrypt= dataset option.

data test(pw=abc encrypt=yes);

  a=1;

run;

if you try to open this dataset by binary editor, you could not read contents.

if not used it, you can access binary data although use password.

Re: How to Apply Raw Level Security in SAS Store Procedure?

kaushalsolanki — Fri, 07 Feb 2020 10:20:02 GMT

Hi Satish,

Thanks for your revert, my requirement is to allow a particular region user to access particular region data only on the basis of his / her AD ID within SAS Stored Process.

Re: How to Apply Raw Level Security in SAS Store Procedure?

kaushalsolanki — Fri, 07 Feb 2020 10:21:15 GMT

Hi @japelin ,

Thanks for your revert, my requirement is to allow a particular region user to access particular region data only on the basis of his / her AD ID within SAS Stored Process.

Re: How to Apply Raw Level Security in SAS Store Procedure?

japelin — Mon, 10 Feb 2020 04:03:58 GMT

The specific data and assumptions will vary depending on whether the regional data is divided at the server, library, dataset, or observation level, and how the user's region is perceived. How about being presented with the environment?

Re: How to Apply Raw Level Security in SAS Store Procedure?

andreas_lds — Mon, 10 Feb 2020 07:57:35 GMT

Please have a look at https://documentation.sas.com/?docsetId=biwaag&docsetTarget=p076g3db8ab6ein109lvq0ssp2hz.htm&docsetVersion=9.4&locale=en