Help Center> Data Warehouse Service (DWS)> Tool Guide> Data Studio> Security Management
Updated on 2024-04-28 GMT+08:00
View PDF

Security Management

Ensure that the operating system and the required software (refer to System Requirements for more details) are updated with the latest patches to prevent vulnerabilities and other security issues.

Login History

  • When you log into a database, Data Studio displays a pop-up with details of the last successful login and failure attempts between the last two successful logins for you on the logged database.

If the pop-up displays the message "Last login details not available", then it implies that the connected database does not support the last login display feature.

Password Expiry Notification

  • Your password will expire within 7 days from the date of notification. If the password expires, contact the database administrator to reset the password.
  • The password must be changed every 90 days.

Securing the Application In-Memory Data

While running Data Studio in a trusted environment, user must ensure to prevent malicious software scanning or accessing the memory which is used to store application data including sensitive information.

Data Encryption for Saved Data

You can ensure encryption of auto saved data by enabling encryption option from Preferences page. Refer to Table 1 for steps to encrypt the saved data.

SQL History

  • 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
  • Some 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: Data Studio