Previous Next JavaScript must be enabled to correctly display this content

## 14 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.

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.