Permissions on SERIAL

From: "Rod Taylor" <rod(dot)taylor(at)inquent(dot)com>
To: "Hackers List" <pgsql-hackers(at)postgresql(dot)org>
Subject: Permissions on SERIAL
Date: 2001-02-23 04:48:15
Message-ID: 026b01c09da6$11858970$2205010a@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Appears that permissions applied to a table using the SERIAL element
aren't carried over to the sequence itself.

Create table with SERIAL, set-up permissions so table is accessible,
attempt to use inserts. No permission to sequence :(

Guess I won't be using this shortcut, between this and them being left
behind it makes SERIAL a pain in the ass. Atleast names for the
sequence are usually predictable.

--
Rod Taylor

There are always four sides to every story: your side, their side, the
truth, and what really happened.

Attachment Content-Type Size
Taylor, Rod B.vcf text/x-vcard 451 bytes

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2001-02-23 06:38:39 Lock structures
Previous Message Bruce Momjian 2001-02-23 04:04:23 Re: [HACKERS] Re: [INTERFACES] Re: Chinese patch for Pgaccess