topic Re: Programmatically retrieve folder permissions in New SAS User

Programmatically retrieve folder permissions

barry_van_dijk — Tue, 20 Aug 2019 12:40:53 GMT

Hi everybody,

I have a folder structure starting from '...\Shared Data\Production' with multiple subfolders underneath. For the different teams in our organisation I configured which team can (or cannot) access these subfolders.

Now I would like to create an overview (report) of which teams (and their users) can access which subfolders and the reports within the subfolders.

Does anyone have an example of how to achieve this? Your help is highly appreciated!

Kind regards,

Barry

Re: Programmatically retrieve folder permissions

Kurt_Bremser — Tue, 20 Aug 2019 13:05:36 GMT

The backslashes tell me that this has to be done on Windows. Since the finfo() function does not return permission properties on Windows, you will need to use operating system tools to retrieve the permission status, and for this, you need to have XCMD enabled in your SAS environment.

Some useful information is found here: https://superuser.com/questions/364083/windows-list-files-and-their-permissions-access-in-command-line

Re: Programmatically retrieve folder permissions

r_behata — Tue, 20 Aug 2019 14:00:55 GMT

Are you referring to the SAS Metadata folder structure ?

Re: Programmatically retrieve folder permissions

barry_van_dijk — Wed, 21 Aug 2019 09:44:31 GMT

I understood that the physical folders I referred to are also part of the metadata folder structure.

When I open the 'Folders' tab in SAS Management Console this folder structure is indeed there (starting from 'Shared Data'). By requesting the folder properties of all subfolders I can find out which users and groups are authorized to the selected folder. This information however I would like to retrieve programmatically to eliminate the manual work to investigate this.

And as Kurt states: it is on Windows indeed...