01007WARNINGTier 3 — Handle with care✅ HIGH confidence

privilege not granted

Category: WarningVersions: All Postgres versions

What this means

SQLSTATE 01007 is raised when a GRANT statement attempts to grant a privilege that the target role already holds, or that cannot be granted due to existing state. The command succeeds without making any change.

Why it happens

1GRANT statement targeting a role that already has the specified privilege

How to reproduce

Granting a privilege that is already held.

trigger — this will ERROR

GRANT SELECT ON employees TO analyst;
GRANT SELECT ON employees TO analyst; -- second GRANT raises 01007

WARNING: privilege not granted

Fix 1: Check existing privileges before granting

When managing role permissions in scripts.

fix

SELECT grantee, privilege_type FROM information_schema.role_table_grants
WHERE table_name = 'employees' AND grantee = 'analyst';

Why this works

Query the privilege catalogue to confirm what is already granted before issuing GRANT.

Sources

📚 Official docs: https://www.postgresql.org/docs/current/errcodes-appendix.html

🔧 Source ref: Class 01 — Warning

Confidence assessment

✅ HIGH confidence

Standard SQL warning. Stable across all Postgres versions.