# 配置参数
DB_CONN=”system/password@fgedudb”
OUTPUT_FILE=”sensitive_data_report.txt”

# 清空输出文件
> $OUTPUT_FILE

echo “敏感数据发现报告” >> $OUTPUT_FILE
echo “生成时间: $(date)” >> $OUTPUT_FILE
echo “” >> $OUTPUT_FILE

# 识别身份证号
echo “1. 身份证号” >> $OUTPUT_FILE
sqlplus -s $DB_CONN << EOF >> $OUTPUT_FILE
SET PAGESIZE 0
SET FEEDBACK OFF
SELECT owner || ‘.’ || table_name || ‘.’ || column_name
FROM dba_tab_columns
WHERE column_name LIKE ‘%ID%’ OR column_name LIKE ‘%CARD%’
AND data_type = ‘VARCHAR2’
AND data_length = 18;EOF
echo “” >> $OUTPUT_FILE

# 识别电话号码
echo “2. 电话号码” >> $OUTPUT_FILE
sqlplus -s $DB_CONN << EOF >> $OUTPUT_FILE
SET PAGESIZE 0
SET FEEDBACK OFF
SELECT owner || ‘.’ || table_name || ‘.’ || column_name
FROM dba_tab_columns
WHERE column_name LIKE ‘%PHONE%’ OR column_name LIKE ‘%TEL%’
AND data_type = ‘VARCHAR2’
AND data_length BETWEEN 10 AND 20;EOF
echo “” >> $OUTPUT_FILE

# 识别银行账号
echo “3. 银行账号” >> $OUTPUT_FILE
sqlplus -s $DB_CONN << EOF >> $OUTPUT_FILE
SET PAGESIZE 0
SET FEEDBACK OFF
SELECT owner || ‘.’ || table_name || ‘.’ || column_name
FROM dba_tab_columns
WHERE column_name LIKE ‘%BANK%’ OR column_name LIKE ‘%ACCOUNT%’
AND data_type = ‘VARCHAR2’
AND data_length BETWEEN 16 AND 20;EOF
echo “” >> $OUTPUT_FILE

echo “敏感数据发现报告生成完成: $OUTPUT_FILE”

# 赋予执行权限
$ chmod +x sensitive_data_discovery.sh

# 运行敏感数据发现脚本
$ ./sensitive_data_discovery.sh
敏感数据发现报告生成完成: sensitive_data_report.txt

# 查看报告
$ cat sensitive_data_report.txt
敏感数据发现报告
生成时间: Wed Mar 31 10:00:00 CST 2026

1. 身份证号
FGEDU.CUSTOMERS.ID_CARD
HR.EMPLOYEES.ID_CARD

2. 电话号码
FGEDU.CUSTOMERS.PHONE
HR.EMPLOYEES.PHONE

3. 银行账号
FGEDU.CUSTOMERS.BANK_ACCOUNT
FINANCE.ACCOUNTS.ACCOUNT_NUMBER