Using the following SQL one can find tables that contain a column name.
In SQLServer
SELECT table_name, column_name
FROM INFORMATION_SCHEMA.COLUMNS
WHERE column_name like ‘%PASSWORD%’
ORDER BY table_name;
In Oracle
SELECT owner, table_name, column_name
FROM dba_tab_columns
WHERE column_name like 'PASSWORD'
ORDER by table_name;
Example:
OWNER TABLE_NAME COLUMN_NAME
—————————— —————————— ——————————
SYS DBA_USERS PASSWORD