Re: Why sequence grant is separated from table?

<div class="moz-cite-prefix">于 2013/6/19 17:47, Szymon Guz 写道:<br /></div><blockquote
cite="mid:CAFjNrYto7C0G_2+UFLcWng3T6rZih5t54P0tRO4w+_Z0wONxMA@mail.gmail.com"type="cite"><div dir="ltr">On 19 June 2013
11:35,Rural Hunter <span dir="ltr"><<a href="mailto:ruralhunter@gmail.com" moz-do-not-send="true"
target="_blank">ruralhunter@gmail.com</a>></span>wrote:<br /><div class="gmail_extra"><div
class="gmail_quote"><blockquoteclass="gmail_quote" style="margin:0 0 0             .8ex;border-left:1px #ccc
solid;padding-left:1ex">Ireally hate the error "permission denied for sequence xxxxx" when I grant on a table but
forgetto grant additionally on the related sequence to users. Can the permission of table and related sequences be
merged?<spanclass="HOEnZb"><font color="#888888"><br /><br /></font></span></blockquote><div><br /></div><div
style="">Ican imagine a situation where you want a user to be granted rights on a table, to use sequence with curval
andnextval functions, but not setval, as it can provide some database problems.</div></div></div></div></blockquote>
oh,is it possible to separately grant nextval and setval on sequence currently?<br /><blockquote
cite="mid:CAFjNrYto7C0G_2+UFLcWng3T6rZih5t54P0tRO4w+_Z0wONxMA@mail.gmail.com"type="cite"><div dir="ltr"><div
class="gmail_extra"><divclass="gmail_quote"><div style=""><br /></div><div style="">What's more, in general, you cannot
saywhich sequence is used for which table, if the sequence is not owned by the
table.</div></div></div></div></blockquote>Can we get it from the column definition such as a serial column?<br
/><blockquotecite="mid:CAFjNrYto7C0G_2+UFLcWng3T6rZih5t54P0tRO4w+_Z0wONxMA@mail.gmail.com" type="cite"><div
dir="ltr"><divclass="gmail_extra"><div class="gmail_quote"><div style=""><br /></div><div style="">Which permissions of
atable do you want to merge with which permissions of sequences?</div></div></div></div></blockquote> At least granting
inserton a table means to grant update on the sequence used by serial columns.<br /><blockquote
cite="mid:CAFjNrYto7C0G_2+UFLcWng3T6rZih5t54P0tRO4w+_Z0wONxMA@mail.gmail.com"type="cite"><div dir="ltr"><div
class="gmail_extra"><divclass="gmail_quote"><div style=""><br /></div><div style="">regards</div><div
style="">Szymon</div></div></div></div></blockquote><br/>