pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: liuyuanyuan <liuyuanyuangogo@gmail.com>
To: 'Guillaume Lelarge' <guillaume@lelarge.info>
Cc: pgsql-admin@postgresql.org
Subject: reply: sql to grant privilege on sequence
Date: Tue, 15 Jul 2014 08:59:52 +0800
Message-ID: <001801cf9fc8$18effb90$4acff2b0$@gmail.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>

My pleasure , and thanks for your reply ~

 

Best Wishes!

Jasmine

 

发件人: Guillaume Lelarge [mailto:guillaume@lelarge.info] 
发送时间: 2014年7月15日 5:05
收件人: liuyuanyuan
抄送: pgsql-admin@postgresql.org
主题: Re: 答复: [ADMIN] sql to grant privilege on sequence

 

2014-07-14 11:31 GMT+02:00 liuyuanyuan <liuyuanyuangogo@gmail.com <mailto:liuyuanyuangogo@gmail.com> >:

Thanks Guillaume! Thanks for your reply !

 

Now that, I got the reason.

I knew  GRANT ON TABLE still works for sequence, but I think use GRANT ON SEQUENCE

in pgAdmin3 of newer version maybe much better. Because GRANT ON SEQUENCE is more clear,

and maybe that’s why developers create this syntax especially for sequence.

That’s only a suggestion, looking forward to hearing from you later~~

 

Well, we have this weird check in pgSequence.cpp:

      if (!GetConnection()->BackendMinimumVersion(8, 2))¬
         sql += GetGrant(wxT("arwdRxt"), wxT("TABLE ") + GetQuotedFullIdentifier());¬
      else¬
         sql += GetGrant(wxT("rwU"), wxT("TABLE ") + GetQuotedFullIdentifier());¬
 

This code is as old as 2006 (commit id 2ef0bfe6cb8eb9d2cf117ca654bbbe0d17d0a784), where Dave added "Add support for PostgreSQL 8.2's CONNECT privilege on databases, and USAGE on sequences".

Pretty sure he meant SEQUENCE instead of TABLE in the else part :)

Fixed.

Thanks for the report.



-- 

Guillaume.

  http://blog.guillaume.lelarge.info

  http://www.dalibo.com

Message-ID: <001801cf9fc8$18effb90$4acff2b0$@gmail.com>
Permalink:  ../001801cf9fc8$18effb90$4acff2b0$@gmail.com/
Also on:    postgresql.org/message-id/001801cf9fc8$18effb90$4acff2b0$@gmail.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: liuyuanyuangogo@gmail.com, guillaume@lelarge.info
  Subject: Re: reply: sql to grant privilege on sequence
  In-Reply-To: <001801cf9fc8$18effb90$4acff2b0$@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox