Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Subject: BUG #19703: information_schema.usage_privileges omits a sequence
 owner's implicit USAGE privilege
To: pgsql-bugs@lists.postgresql.org
From: PG Bug reporting form <noreply@postgresql.org>
Cc: imchifan@163.com
Reply-To: imchifan@163.com, pgsql-bugs@lists.postgresql.org
Date: Sat, 19 Sep 2026 13:44:36 +0000
Message-ID: <19703-49d6f1796001a6d7@postgresql.org>
Auto-Submitted: auto-generated
Archived-At: 
 <https://www.postgresql.org/message-id/19703-49d6f1796001a6d7%40postgresql.org>
Precedence: bulk

The following bug has been logged on the website:

Bug reference:      19703
Logged by:          Qifan Liu
Email address:      imchifan@163.com
PostgreSQL version: 18.6
Operating system:   Linux/amd64
Description:       =20

For a newly created sequence, has_sequence_privilege reports that the owner
has USAGE, but information_schema.usage_privileges omits that privilege. The
view reports the owner privilege only after the same USAGE privilege is
redundantly granted explicitly.

Steps to reproduce
------------------
\pset tuples_only on
\pset format unaligned
DROP SEQUENCE IF EXISTS bugseer_postgres_00004_seq_acl;
CREATE SEQUENCE bugseer_postgres_00004_seq_acl;

SELECT 'implicit_privilege=3D' || has_sequence_privilege(
  current_user, 'bugseer_postgres_00004_seq_acl', 'USAGE');
SELECT 'implicit_view_rows=3D' || count(*)
FROM information_schema.usage_privileges
WHERE object_schema =3D current_schema
  AND object_name =3D 'bugseer_postgres_00004_seq_acl'
  AND object_type =3D 'SEQUENCE'
  AND grantee =3D current_user
  AND privilege_type =3D 'USAGE';

GRANT USAGE ON SEQUENCE bugseer_postgres_00004_seq_acl TO CURRENT_USER;
SELECT 'explicit_view_rows=3D' || count(*)
FROM information_schema.usage_privileges
WHERE object_schema =3D current_schema
  AND object_name =3D 'bugseer_postgres_00004_seq_acl'
  AND object_type =3D 'SEQUENCE'
  AND grantee =3D current_user
  AND privilege_type =3D 'USAGE';

Actual result
-------------
implicit_privilege=3Dtrue
implicit_view_rows=3D0
GRANT
explicit_view_rows=3D1

Expected result
---------------
information_schema.usage_privileges should report one owner USAGE row before
the redundant explicit grant, and the row count should remain one afterward.

Additional information
----------------------
The issue was reproduced on PostgreSQL 20devel, PostgreSQL 18.6, and
PostgreSQL 17.11.