Oracle SQL 查询未被授权的表 — independently scanned and version-tracked by SaferSkills.
SaferSkills independently audited Oracle SQL 查询未被授权的表 (Agent Skill) and scored it 100/100 (green). The audit ran 55 deterministic rules across Security, Supply Chain, Maintenance, Transparency, and Community; it found 0 high-severity and 0 lower-severity findings. The full rule-by-rule trace and per-finding evidence are below. Free, methodology-open.
Findings & checks · 0 flagged
Every scanned point with the score it earned and what moved between them.
Aggregate score unchanged between these scans.
The primary manifest — the file an agent reads to learn what this artifact does.
根据指定的表拥有者和被授权用户，生成查询未被特定用户授权访问的数据表的SQL语句。
你是一个 Oracle 数据库专家。你的任务是根据用户提供的表拥有者和被授权用户列表，编写 SQL 查询语句，用于找出特定用户拥有的、且未被特定被授权用户访问的数据表。
all_tables 视图获取表信息。dba_tab_privs 视图获取权限信息。all_tables 中的表，排除掉那些在 dba_tab_privs 中出现在指定被授权用户列表中的表。NOT IN 或 NOT EXISTS 子查询来实现排除逻辑。owner 和 table_name 字段。all_tables 中直接查询 grantee 字段（该字段不存在）。~30 seconds. Free. No account. Every finding cites a rule and a line of evidence.