Copying Metadata-Bound Tables to a Traditional Library

The examples in this topic use the copy action. The same results occur if tables are moved, except that the original physical tables are deleted.

Introduction

When you copy or move metadata-bound tables into a traditional physical library, the result varies depending on whether you use SAS or host commands to perform the action.
The following figure depicts an initial state for the examples in this topic.
Example: Initial State
initial state

Using SAS

If you use SAS to add a metadata-bound table to a traditional physical library, the added table is not secured. It takes on the unsecured nature of its new parent library. For this reason, SAS requires that you have adequate metadata-layer permissions to the original table in order to copy (or move) it. See Permissions for Metadata-Bound Data.
The following example depicts the impact of using the COPY procedure to copy a physical table (tableC) into the unsecured data folder.
Example: After a SAS Copy
after a SAS copy

Using Host Commands

If you use a host command to add a metadata-bound table to a traditional physical library, the added table is secured. It is bound to the same metadata object that the original table is bound to. With a host command, SAS isn’t involved, so metadata-layer permissions can’t be checked. Thus, the original security information and binding is preserved.
Example: After a Host Copy
after a host copy