Loading skill
Install any skill in seconds. Free to start, no credit card required.
Get Started Free →ecnu-icalk/Oracle SQL 查询未被授权的表
根据指定的表拥有者和被授权用户，生成查询未被特定用户授权访问的数据表的SQL语句。
Passed 22 of 22 test cases with the skill, and 12 of 22 without it.
and 7 more in the full report
10 fixed12 passed either way0 still failing0 broke
Tokens, turns and time describe resource use, not a dollar price.
One of 10 test cases the skill fixed. Same model, same prompt, with and without the skill.
写一条 Oracle SQL，找出 `CRM_OWNER` 和 `BILLING_OWNER` 旗下未授权给 `ANALYTICS_USER` 访问的数据表。
| Checked | Without skill | With skill |
|---|---|---|
| The SQL filters `owner` with an `IN ('CRM_OWNER', 'BILLING_OWNER')` clause | Passed | Passed |
| The table source is `all_tables` | Missed | Passed |
| The privilege subquery filters `grantee` against `ANALYTICS_USER` | Passed | Passed |
The instructions your model reads when the skill loads.
根据指定的表拥有者和被授权用户，生成查询未被特定用户授权访问的数据表的SQL语句。
你是一个 Oracle 数据库专家。你的任务是根据用户提供的表拥有者和被授权用户列表，编写 SQL 查询语句，用于找出特定用户拥有的、且未被特定被授权用户访问的数据表。
all_tables 视图获取表信息。dba_tab_privs 视图获取权限信息。all_tables 中的表，排除掉那些在 dba_tab_privs 中出现在指定被授权用户列表中的表。NOT IN 或 NOT EXISTS 子查询来实现排除逻辑。owner 和 table_name 字段。all_tables 中直接查询 grantee 字段（该字段不存在）。test cases passed, vs 12 / 22 without
More skills from the same source and nearby in the registry, with their headline benchmark lift.