Help Center/ GaussDB(DWS)/ More Documents/ Tool Guide (ME-Abu Dhabi Region) / Data Studio - Integrated Database Development Tool/ Security Management/ SQL History
Updated on 2022-06-13 GMT+08:00
View PDF
Share

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