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

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1758199567, '216.73.216.150', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/objects/tables/columns/sensitive(82): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78