Search notes:

Oracle: Sensitive columns

Senstitive columns can be queried from the base tables like so:
select
   own.name owner,
   obj.name obj_name,
   col.name col_name
from
   sys.obj$       obj                               join
   sys.user$      own  on obj.owner# = own.user#    join
   sys.col$       col  on obj.obj#   = col.obj#
where
   bitand(col.property, 8796093022208) > 0
order by
   owner,
   obj_name,
   col_name;


OWNER  OBJ_NAME              COL_NAME
------ --------------------- -------------
SYS    CDB_LOCAL_ADMINAUTH$  PASSWD
SYS    DEFAULT_PWD$          PWD_VERIFIER
SYS    ENC$                  COLKLC
SYS    HISTGRM$              ENDPOINT
SYS    HISTGRM$              EPVALUE
SYS    HISTGRM$              EPVALUE_RAW
SYS    HIST_HEAD$            HIVAL
SYS    HIST_HEAD$            LOWVAL
SYS    HIST_HEAD$            MAXIMUM
SYS    HIST_HEAD$            MINIMUM
SYS    LINK$                 AUTHPWD
SYS    LINK$                 AUTHPWDX
SYS    LINK$                 PASSWORD
SYS    LINK$                 PASSWORDX
SYS    PDB_CREATE$           SQLSTMT
SYS    PDB_SYNC$             LONGSQLTXT
SYS    PDB_SYNC$             SQLSTMT
SYS    USER_HISTORY$         PASSWORD
SYS    XS$VERIFIERS          VERIFIER
Tables with sensititive columns can be queried like so:
select
   own.name      as tab_owner,
   obj.name      as tab_name
from
   sys.tab$  tab                           join
   sys.obj$  obj on tab.obj#   = obj.obj#  join
   sys.user$ own on obj.owner# = own.user#
where
   bitand(tab.property, power(2, 89)) > 0
order by
   tab_name

Index