Help Center> Data Warehouse Service (DWS)> Tool Guide (Kuala Lumpur Region)> Data Studio - Integrated Database Development Tool> Security Management> SQL History
Updated on 2022-08-16 GMT+08:00
View PDF

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