The 1P1 statement allows you to generate, delete and rename passwords. Please note:
The 1P1 entry must begin in column 1.
A statement can contain a maximum of 130 characters.
Several 1P1'BLANK'GP, 1P1'BLANK'DP and 1P1'BLANK'CP statements can be issued.
Legal combinations:
1P1'BLANK'DP and 1P1'BLANK'CP statements
All 1P1'BLANK'DP statements must come before the first 1P1'BLANK'CP statement.1P1'BLANK'DP and 1P1'BLANK'GP statements
All 1P1'BLANK'DP statements must come before the first 1P1'BLANK'GP statement.
Illegal combinations:
1P1'BLANK'CP, 1P1'BLANK'DP and 1P1'BLANK'GP statements
1P1'BLANK'CP and 1P1'BLANK'GP statements
1P1 statements must be entered in ascending order by password.
Generating a password and assigning global authorization
1P1'BLANK'GP'BLANK'password[,AR={ E | Y | N }][,OR={ E | Y | N }][,AU={ E | Y | N }]
[,OU={ E | Y | N }][,OD={ E | Y | N }]
password
The password is a three-character combination of letters, digits and special characters; it can be specified in printable form or hexadecimal notation. For example, the password AAA in hexadecimal notation is X'C1C1C1'.
When specifying the password in printable form, note the following:
The password must not contain any NIL characters.
The first character of the password must not be a blank.
The password must not begin with the string X'.
When specifying the password in hexadecimal notation, all combinations except X'000000', X'FFFFFF' and X'404040' are permitted.
In the LIST log, every password is listed in both printable form and hexadecimal notation.
The following operands specify the type of access authorization:
AR | Reads attributes in the table records specified by OR. |
| OR | Reads table records; the attributes read are specified by AR. |
| AU | Updates attributes in the table records specified by OU. |
| OU | Updates table records as specified by AU. |
| OD | Deletes records from a table. |
The following operands specify authorization values:
E | Access authorization is assigned by subsequent 1P2 or 1P3 statements for individual attributes or records of a table. |
Y | Access authorization applies to all attributes or records of a table. |
| N | Access authorization for all attributes and records of a table is withdrawn from the password for the specified access mode (default). |
Default function:
If no authorization value is specified for any access mode, all access authorization is withdrawn from the password.
Example
The password ABC allows all attributes to be read but only some to be updated: 1P1'BLANK'GP'BLANK'ABC,AR=Y,AU=E
Deleting a password
1P1'BLANK'DP'BLANK'password['BLANK'password]...
password
Specify the password to be deleted. If you want to delete several passwords, you must separate them with blanks. You can enter the passwords in printable form or hexadecimal notation (see the description of the GP operand).
Example
The passwords AXZ and TTP are to be deleted:
1P1'BLANK' DP'BLANK' AXZ'BLANK' TTP
Changing a password
1P1'BLANK'CP'BLANK'password-old1,password-new1['BLANK'password-old2,password-new2]...
You can enter the passwords in printable form or hexadecimal notation (see the description of 1P1'BLANK'GP).
You can use a single 1P1 statement to enter several changes, separated by blanks.
A change cannot be specified separately in two different 1P1 statements.
Example
The password ABB is to be changed to BBB:
1P1'BLANK' CP'BLANK' ABB,BBB