Does Toad query SYS.ALL_ENCRYPTED_COLUMNS?
Toad for Oracle does query this view when the user clicks:
Schema Browser | Tables | tablename | Columns tab
The following query is fired off in the background (along with other sql statements) to gather the information e.g.
SESSION: schema@db1
select column_name, encryption_alg, salt
from sys.ALL_ENCRYPTED_COLUMNS
where owner = :own
and table_name = :tn
Depending on the table being viewed, Toad will query
1. SYS.USER_ENCRYPTED_COLUMNS - if viewing a table owned by the user
2. SYS.ALL_ENCRYPTED_COLUMNS - if viewing a table owned by another user and
View | Toad Options | Startup | 'Check for Access to DBA views' is UNCHECKED
3. SYS.DBA_ENCRYPTED_COLUMNS - if viewing a table owned by another user and
View | Toad Options | Startup | 'Check for Access to DBA views' is CHECKED
Toad also queries the view when generating the DDL script for a table.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center