doc-exports/docs/dws/tool/DWS_DS_153.html
Lu, Huayi 4194b50d78 DWS TOOL 811 version
Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
2022-12-14 20:46:26 +00:00

2.3 KiB

SQL History

The following information is critical to manage security for Data Studio:

  • SQL History scripts are not encrypted.
  • The SQL History list does not display sensitive queries that contain the following keywords:
    • Alter Role
    • Alter User
    • Create Role
    • Create User
    • Identified by
    • Password
  • Few query syntax examples are listed below:
    • ALTER USER name WITH ] option [ ...
    • CREATE USER name [ [ WITH ] option [ ... ] ]
    • CREATE ROLE name [ [ WITH ] option [ ... ] ]
    • ALTER ROLE name [ [ WITH ] option [ ... ] ]