Programmatically retrieve folder permissions

[barry_van_dijk]

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

[Kurt_Bremser]

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-li...

[r_behata]

Are you referring to the SAS Metadata folder structure ?  

[barry_van_dijk]

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...