SYSTEM 2000 Passwords

SYSTEM 2000 provides data security with a multi-level password system. Three types of passwords (consisting of 1 to 4 alphanumeric characters with no blanks) can be associated with a SYSTEM 2000 database:

The holder of the master password has unqualified access to the database. This is the password under which a database is created. The holder of the master password can also assign multiple secondary passwords with access authorities assigned to individual database components and a DBA password with access authorities assigned to individual SYSTEM 2000 statements.

The holder of a secondary password can have retrieval (R), update (U), where-clause (W), or no access (N) authority 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 type of access to the database the password allows. For example, the holder of a secondary password can have retrieval and where-clause authority for all database components but no authority to update them.

The DBA password provides a level of security between the master password and secondary passwords. This password enables the DBA to administer databases without being able to access the data stored in them.

For the SAS/ACCESS interface to access SYSTEM 2000 data, you must supply a SYSTEM 2000 password in both the access descriptor and the view descriptor. The passwords can be the same or different. However, the password assigned to the view descriptor must include the data described by the access descriptor. The view descriptor password can be stored in the view, or you can provide (or override) a view descriptor password with a SAS data set option.