Problem Note 35783: The %MDSECDS security reporting macro with MEMBERTYPE set to Table or Cube returns other object types that were not requested
 |  |  |  |
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 child objects that make up the requested object type. Some examples of objects that have such child object associations are Table and Cube objects. For example, if you request MEMBERTYPES="Table", you will also receive authorization information for Column objects. If you request MEMBERTYPES="Cube", you will also see information for Level, Dimension, and Hierarchy objects.
To omit the authorization information for the additional 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:
or...
Also refer to SAS Note 35778 for a similar problem relating to additional Folder objects.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS Metadata Server | z/OS | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows XP 64-bit Edition | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft® Windows® for x64 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows XP Professional | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Windows Vista | 9.2 TS2M0 | 9.3 TS1M0 | ||
| 64-bit Enabled AIX | 9.2 TS2M0 | 9.3 TS1M0 | ||
| 64-bit Enabled HP-UX | 9.2 TS2M0 | 9.3 TS1M0 | ||
| 64-bit Enabled Solaris | 9.2 TS2M0 | 9.3 TS1M0 | ||
| HP-UX IPF | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Linux | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Linux for x64 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Solaris for x64 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| 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:24:50 |
| Date Created: | 2009-05-04 11:12:25 |