SAS lets you control access to
SAS data sets and access descriptors by associating one or more SAS
passwords with them. When you create an access descriptor, the connection
information that you provide is stored in the access descriptor and
in any view descriptors based on that access descriptor. The password
is stored in an encrypted form. When these descriptors are accessed,
the connection information that was stored is also used to access
the DBMS table or view. To ensure data security, you might want to
change the protection on the descriptors to prevent others from seeing
the connection information stored in the descriptors.
When you create or update
view descriptors, you can use a SAS data set option after the ACCDESC=
option to specify the access descriptor password, if one exists.
In this case, you are
not assigning
a password to the view descriptor that is being created or updated.
Instead, using the password grants you permission to use the access
descriptor to create or update the view descriptor. Here is an example:
proc access dbms=sybase accdesc=adlib.customer
(alter=rouge);
create vlib.customer.view;
select all;
run;
By specifying the ALTER
level of password, you can read the AdLib.Customer access descriptor
and create the Vlib.Customer view descriptor.