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

From: "Vadim B(dot) Mikheev" <vadim(at)sable(dot)krasnoyarsk(dot)su>
To: mrogan(at)fpelectronics(dot)com
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] SELECT currval('SEQ') broken?
Date: 1998-02-25 23:21:15
Message-ID: 34F4A76B.E83A08BD@sable.krasnoyarsk.su
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Vadim B. Mikheev 1998-02-26 01:02:31 mode of libs
Previous Message Danny White 1998-02-25 23:08:30 unsubscribe