Menu
根据指定的表拥有者和被授权用户，生成查询未被特定用户授权访问的数据表的SQL语句。
The review-first prompt is selected by default. You can switch to a direct command or download a local copy.
Read SKILL.md and any companion files shown by SkillsMP before deciding whether to install.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
A direct command skips the review prompt. Inspect the source before running it.
npx skills add https://github.com/ECNU-ICALK/AutoSkill --skill oracle-sqlThe command stays on one line. Scroll horizontally to inspect it before copying.
Prefer a local copy? Download the files currently available to SkillsMP.
Based on SOC occupation classification
Showing SKILL.md
| id | b0e5740f-3bac-44dd-8b5f-d4bafb2eda52 |
| name | Oracle SQL 查询未被授权的表 |
| description | 根据指定的表拥有者和被授权用户，生成查询未被特定用户授权访问的数据表的SQL语句。 |
| version | 0.1.0 |
| tags | ["Oracle","SQL","权限查询","dba_tab_privs","数据库"] |
| triggers | ["查出 a用户和b用户 没有权限访问c用户的表","查询在 C 用户下不被 A 和 B 两个用户授权的数据表","查询在 AE ,AR用户下不被 A 用户授权的数据表","写sql查没有权限的表","查询未被授权的表"] |
根据指定的表拥有者和被授权用户，生成查询未被特定用户授权访问的数据表的SQL语句。
你是一个 Oracle 数据库专家。你的任务是根据用户提供的表拥有者和被授权用户列表，编写 SQL 查询语句，用于找出特定用户拥有的、且未被特定被授权用户访问的数据表。
all_tables 视图获取表信息。dba_tab_privs 视图获取权限信息。all_tables 中的表，排除掉那些在 dba_tab_privs 中出现在指定被授权用户列表中的表。NOT IN 或 NOT EXISTS 子查询来实现排除逻辑。owner 和 table_name 字段。all_tables 中直接查询 grantee 字段（该字段不存在）。Manage personal local Agent Skill files as an installable skill manager. Proactively and periodically detect reusable user-specific, team-specific, or broadly reusable skill material during or after meaningful sessions; run non-blocking extraction checks; offer candidate skill titles or accept a user-supplied topic when extraction direction is ambiguous; preserve the appropriate output language; search local and external skill ecosystems for similar skills; score candidates by evidence, recurrence, personal value, and portability; fully draft proposed skills or diffs before asking for approval; then, after explicit user approval, discard, improve, merge, or create `SKILL.md` folders.
布置结构化家庭作业，引导求助者记录现实互动事件、自动思维及情绪反应，并设计简易验证行动（如主动询问、观察反证），用于检验投射性认知偏差。适用于已识别出具体非理性信念（如‘别人肯定不喜欢我’）且情绪稳定者。
结构化8次CBT咨询流程，按评估性会谈→咨询性会谈→巩固性会谈三阶段推进，整合悬搁接地技术与认知行为策略，专用于强迫症伴轻度抑郁状态、具自省力与作业执行力的成年来访者。