We currently don't represent the sequence privileges in the information
schema.  We could perhaps do a subset of them.

In the SQL standard, there is only the USAGE privilege, and its only
purpose (AFAICT) is to allow the NEXT VALUE FOR expression.
PostgreSQL's nextval(), by contrast, requires both USAGE and UPDATE
privileges.

So with regard to the information schema, we could

a) show USAGE privileges as is (and perhaps SELECT and UPDATE as is, as
well)

b) show USAGE privileges only if UPDATE is also granted

c) show nothing, avoiding the whole issue.

Any ideas?



-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to