In this example, you
use the REMOVE statement to remove the metadata binding from an existing
physical library.
libname secdemo 'path';
proc authlib library=secdemo;
remove pw=secret/;
run;
Here are some important
points about the preceding code:
-
A forward slash (/) is entered
at the end of the password. For a password change, the slash separates
the current and new passwords. For password removal, the slash indicates
the end of the current password that is being removed and is not being
replaced with another password).
-
The SECUREDFOLDER and SECUREDLIBRARY
parameters are not specified. It is not necessary to use these parameters,
because the physical directory of the specified library (secdemo)
contains information that references a particular secured folder and
secured library object.
-
The preceding code deletes the
corresponding secured library object and secured table objects from
the metadata.
Tip
If those objects are still
visible in SAS Management Console, right-click the
Secured
Libraries
folder and select
Refresh from
the popup menu.
-
Connection information for the
metadata server is not explicitly supplied. This example assumes that
your SAS session already knows how to connect to the target metadata
server.
Note: The REMOVE statement unbinds
only those physical tables that are located within the specified library
(directory). If a table is host-copied from a metadata-bound library
to another location, that table’s security location information
will be unaffected by subsequent REMOVE statements against the metadata-bound
library. In order to reestablish access to the table, corrective action
against the table is necessary.