vpruthi/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
doc-exports/docs/dws/tool/DWS_DS_153.html
Lu, Huayi 346ac31da9 DWS TG 8.1.3.200 VERSION 
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Reviewed-by: Jiang, Beibei <beibei.jiang@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
2023-08-28 09:20:17 +00:00

2.3 KiB
Raw Permalink Blame History

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 [ ... ] ]
Parent topic: Security Management