Re: Owner and privileges on sequences

>> ALTER SEQUENCE ... OWNER TO ...;
>> GRANT ... ON SEQUENCE ... TO ...;
>> ...
>>
>
>I don't quite understand why it should be your way and not the other. Care
>to
>explain?
>
>Regards.
>
>
>--
>Guillaume.

Oops, sorry, there is no syntax ALTER SEQUENCE ... OWNER TO ...;

But since release 8.2, GRANT ON SEQUENCE is available. As written in the
release notes, "GRANT ON TABLE for sequences is still supported for backward
compatibility".

It's quite easy to explain the reason to make such a modification. As also
written in the release notes mentioned above, "this <GRANT ON SEQUENCE> was
added for setting sequence-specific permissions". It might be strange for
someone to operate a command like "GRANT USAGE ON TABLE ..." generated for a
sequence, since there is no meaningful USAGE privilege for tables. Although
it is correct and works.

Dmitry.