15 Password Policy
The Password Policy Service in Plato provides the facility to maintain the configurations for generation of a password string which can be used to encrypt email attachments.
PLATO_TM_PASSWORD_POLICY_MASTER
| FIELD | DATATYPE | SIGNIFICANCE |
|---|---|---|
| MODULE_CODE | VARCHAR2(100 BYTE) | Module Code or App Id of the service which is using the password policy service. |
| POLICY_CODE | VARCHAR2(100 BYTE) | Unique Identifier corresponding to each policy in a service. |
| POLICY_DESCRIPTION | VARCHAR2(4000 BYTE) | Description of the policy being used in a service. |
| POLICY_TEXT | VARCHAR2(4000 BYTE) | Explanation of the password of an attachment so that the user can open the attachment. |
| SERVICE_NAME | VARCHAR2(100 BYTE) | Name of the service which is using the password policy service. |
| CONVERT_TO_UPPERCASE | VARCHAR2(4000) | To determine if the password should be converted to uppercase |
Primary Key - Combination of MODULE_CODE and POLICY_CODE
PLATO_TM_PASSWORD_POLICY_DETAIL
| FIELD | DATATYPE | SIGNIFICANCE |
|---|---|---|
| POLICY_CODE | VARCHAR2(100 BYTE) | Unique Identifier corresponding to each policy in a service. |
| SEQ_NO | NUMBER | Sequence Number of a particular parameter in the password. |
| DOMAIN_ATTR_JSON_PATH | VARCHAR2(100 BYTE) | JSON Path of the value in the product service to be fetched for this field. |
| FIELD_NAME | VARCHAR2(100 BYTE) | Name of the field used for password generation. |
| FIELD_TYPE | VARCHAR2(20 BYTE) | Value can either be STRING or DATE (case insensitive). In case of DATE, the value of this corresponding field is expected in the format YYYY-MM-DD And the password component of this field is determined accordingly. |
| FIRST_CHAR | VARCHAR2(20 BYTE) |
If FIELD_TYPE is STRING, then this will be a number containing the number of characters to be added from the start of the field value to the password. If FIELD_TYPE is DATE, then this will be a string containing the components of the date to be added to the password. |
| LAST_CHAR | VARCHAR2(20 BYTE) |
If FIELD_TYPE is STRING, then this will be a number containing the number of characters to be added from the end of the field value to the password. If FIELD_TYPE is DATE, then this value is not applicable |
| DEFAULT_VALUE | VARCHAR2(100 BYTE) | Default Value of the password component of this field in case any configurations above are not maintained. |