Problem Note 35778: The %MDSECDS macro returns folder information along with the specified member type
 |  |  |  |
The documentation for the %MDSECDS security reporting macro states that you can use the MEMBERTYPES= parameter to limit the output by object type. This implies that only objects of the type specified are included in the output from the macro.
However, due to the way the object metadata is retrieved, the output will also contain authorization information for all folder objects in the requested objects' metadata folder hierarchy.
If you wish to omit the authorization information for the folder objects, you can work around this problem by further subsetting the output data set, or view by including a WHERE clause similar to the following in the code you use to generate the report listing:
where publictype not in ('RootFolder','Folder');
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Metadata Server | 64-bit Enabled AIX | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Windows Vista for x64 | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Windows Vista | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows XP Professional | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2008 for x64 | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 for x64 | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft® Windows® for x64 | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows XP 64-bit Edition | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| z/OS | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| 64-bit Enabled HP-UX | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| 64-bit Enabled Solaris | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| HP-UX IPF | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Linux | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Linux for x64 | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Solaris for x64 | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
In addition to the types requested on the MEMBERTYPES= parameter, the %MDSECDS security reporting macro also returns authorization information for all the folders in the path to those requested objects.
| Type: | Problem Note |
| Priority: | medium |
| Topic: | Common Programming Tasks ==> Selecting Data Data Management ==> Data Sources ==> Metadata Data Management ==> Data Sources ==> SAS Data Sets/Tables System Administration ==> Security ==> Permissions System Administration ==> Servers ==> Metadata |
| Date Modified: | 2011-07-20 11:14:52 |
| Date Created: | 2009-05-04 09:53:04 |