BookmarkSubscribeRSS Feed
barry_van_dijk
Obsidian | Level 7

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

3 REPLIES 3
Kurt_Bremser
Super User

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
Barite | Level 11

Are you referring to the SAS Metadata folder structure ?  

barry_van_dijk
Obsidian | Level 7

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

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 705 views
  • 0 likes
  • 3 in conversation