SAS/ACCESS Interface to SYSTEM 2000 Data Management Software: Reference |
SYSTEM 2000 software
provides data security with a multi-level password system. Three types of
passwords (consisting of one to four alphanumeric characters with no blanks)
can be associated with a SYSTEM 2000 database:
- a master password - required
- secondary
passwords
- a DBA password.
The master
password holder has unqualified access to the database. This is the password
under which a database is created. The master password holder can also assign
multiple secondary passwords with authorities assigned to individual database
components and a DBA password with authorities assigned to individual SYSTEM
2000 statements.
A secondary password holder can have retrieval, update, where-clause, or no
access for any combination of database components. An authority is a SYSTEM
2000 code that associates a secondary password with a database component and
determines what kind of access to the database the password has. These authorities
are designated as R-, U-, W- and N-authorities. For example, a secondary password
holder can have retrieval and where-clause authority for all components but
no authority to update them.
The DBA password
provides a level of security between that of the master password and the secondary
passwords. This password allows the DBA to administer databases without being
able to access the data stored in them.
For the SAS/ACCESS interface, you must supply a SYSTEM
2000 password in both the access descriptor and the view descriptor to access
SYSTEM 2000 data. They can be the same or different passwords; however, the
password assigned to the view descriptor must encompass the data described
by the access descriptor. The view descriptor password can be stored in the
view or you can supply (or override) one with a SAS data set option.
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.