sequence privileges in information schema

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: sequence privileges in information schema
Date: 2011-04-26 20:24:12
Message-ID: 1303849452.12063.3.camel@vanquo.pezone.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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?

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2011-04-26 20:28:51 Re: SR standby hangs
Previous Message Merlin Moncure 2011-04-26 20:19:35 Re: Bad COMPACT_ALLOC_CHUNK size in tsearch/spell.c?