[jira] [Updated] (IMPALA-12993) Encrypt password in JDBC table properties when saving into HMS DB

["Wenzhe Zhou (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IMPALA-12993?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Wenzhe Zhou updated IMPALA-12993:
---------------------------------
        Parent: IMPALA-5741
    Issue Type: Sub-task  (was: Bug)

> Encrypt password in JDBC table properties when saving into HMS DB
> -----------------------------------------------------------------
>
>                 Key: IMPALA-12993
>                 URL: https://issues.apache.org/jira/browse/IMPALA-12993
>             Project: IMPALA
>          Issue Type: Sub-task
>            Reporter: Wenzhe Zhou
>            Priority: Major
>
> The password of remote database is specified in table property 'dbcp.password' when creating Impala external JDBC table. Currently all table properties are saved in HMS DB as clear text. It's more secure to encrypt password in JDBC table properties when saving the table metadata into HMS and decrypt it when reading from HMS.
> IMPALA-12928 makes the value of dbcp.password table property been masked in the output of 'describe formatted' and 'show create table' commands.  In Impala log file, the password like other sensitive information within SQL statement text can be redacted by setting up a regular expressions.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org