Re: [HACKERS] SELECT currval('SEQ') broken?

Vadim B. Mikheev <vadim@sable.krasnoyarsk.su>

From: "Vadim B. Mikheev" <vadim@sable.krasnoyarsk.su>
To: mrogan@fpelectronics.com
Cc: pgsql-hackers@postgreSQL.org
Date: 1998-02-25T23:21:15Z
Lists: pgsql-hackers
Michael J. Rogan wrote:
> 
> Hello
> 
> I like the added security of 6.3 however how do you grant access to
> SELECT currval('SEQ') AS id
> I get a permission error on seq.currval?
> 
> I figured out how to use CVSUP so I am grabbing the latest version.
> 
> If this is fixed in it then great otherwise any ideas?

I don't remember - did we NO_ACCESS to a table for public
as default or not ?
If yes then you have to GRANT permissions on sequences...

Vadim