SQL - show authority for IFS folders

By kimot, 25 December, 2022
WITH objs AS (SELECT path_name 
   FROM TABLE (QSYS2.IFS_OBJECT_STATISTICS(START_PATH_NAME => '/usr'))) 
SELECT * FROM objs, TABLE(QSYS2.IFS_OBJECT_PRIVILEGES(PATH_NAME)) WHERE authorization_name = 'user';