sequence privileges in information schema - Mailing list pgsql-hackers

From Peter Eisentraut
Subject sequence privileges in information schema
Date
Msg-id 1303849452.12063.3.camel@vanquo.pezone.net
Whole thread Raw
Responses Re: sequence privileges in information schema  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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?




pgsql-hackers by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Bad COMPACT_ALLOC_CHUNK size in tsearch/spell.c?
Next
From: Tom Lane
Date:
Subject: Re: SR standby hangs