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:
where publictype ne 'Column';
or...
where publictype not in ('Level','Dimension','Hierarchy');
Also refer to SAS Note 35778 for a similar problem relating to additional Folder objects.
Operating System and Release Information
| 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 |
*
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.
%MDSECDS also returns all "child" objects associated with the Table or Cube, such as Column, Level, Dimension, Hierarchy object types.
| 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 |
