Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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

So with regard to the information schema, we could

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

b) show USAGE privileges only if UPDATE is also granted

c) show nothing, avoiding the whole issue.

Any ideas?


pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group