Thread: Permissions on SERIAL

Permissions on SERIAL

From
"Rod Taylor"
Date:
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.