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
| 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 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
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 |
