Chapter Contents

Previous

Next
SAS/ACCESS Interface to SYSTEM 2000 Data Management Software: Reference

SYSTEM 2000 Passwords

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:

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.


Chapter Contents

Previous

Next

Top of Page

Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.