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