Re: Why sequence grant is separated from table?

Rural Hunter <ruralhunter@xxxxxxxxx> · Wed, 19 Jun 2013 18:06:11 +0800



    于 2013/6/19 17:47, Szymon Guz 写道:

    
      On 19 June 2013 11:35, Rural Hunter <ruralhunter@xxxxxxxxx>
        wrote:

        
            I really
              hate the error "permission denied for sequence xxxxx" when
              I grant on a table but forget to grant additionally on the
              related sequence to users. Can the permission of table and
              related sequences be merged?

                  
            I can imagine a situation where you want a
              user to be granted rights on a table, to use sequence with
              curval and nextval functions, but not setval, as it can
              provide some database problems.
          
        
    oh, is it possible to separately grant nextval and setval on
    sequence currently?

    
            What's more, in general, you cannot say which
              sequence is used for which table, if the sequence is not
              owned by the table.
          
        
    Can we get it from the column definition such as a serial column?

    
            Which permissions of a table do you want to
              merge with which permissions of sequences?
          
        
    At least granting insert on a table means to grant update on the
    sequence used by serial columns.

    
            regards
            Szymon