From: liuyuanyuan <liuyuanyuangogo@gmail.com>
To: 'Guillaume Lelarge' <guillaume@lelarge.info>
Cc: pgsql-admin@postgresql.org
Subject: 答复: [ADMIN] sql to grant privilege on sequence
Date: Mon, 14 Jul 2014 17:31:01 +0800
Message-ID: <020f01cf9f46$5fff2ec0$1ffd8c40$@gmail.com> (raw)
In-Reply-To: <CAECtzeXrh1z1-gC=uPM84ioRmKKNiesrENpWh11aq6emO6+Zmg@mail.gmail.com>
References: <01e701cf9f2b$408100c0$c1830240$@gmail.com>
<CAECtzeXrh1z1-gC=uPM84ioRmKKNiesrENpWh11aq6emO6+Zmg@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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~~
Regards !
Yours,
Jasmine
发件人: Guillaume Lelarge [mailto:guillaume@lelarge.info]
发送时间: 2014年7月14日 16:50
收件人: liuyuanyuan
抄送: pgsql-admin@postgresql.org
主题: Re: [ADMIN] sql to grant privilege on sequence
Le 14 juil. 2014 08:20, "liuyuanyuan" <liuyuanyuangogo@gmail.com <mailto:liuyuanyuangogo@gmail.com> > a écrit :
>
> Hi, Hackers!
>
> I got a question about sequence SQL of pgadmin3 , such as pgAdmin3 of PostgreSQL9.3.
>
> I found when I GRANT privilege on sequence by pgAdmin3 tool, it’s always show me sql like:
>
> GRANT SELECT, UPDATE ON TABLE sequence_name TO ….
>
> Rather than:
>
> GRANT SELECT, UPDATE ON SEQUENCE sequence_name TO ….
>
>
>
> For example:
>
> When I use pgAdmin3 TO create a sequence, I input SEQUENCE NAME – seq1 ,and add privilege SELECT to public,
>
> Then the SQL shows: GRANT .. ON TABLE …
>
>
>
>
>
> I checked the documentation of PostgreSQL 9.3 (see http://www.postgresql.org/docs/9.3/interactive/sql-grant.html),
>
> Then I know the privileges grant on sequence are only a part of that on table.
>
> Then I want to know, why to use GRANT ON TABLE ? why not to use GRANT ON SEQUENCE ?
>
Because that was the way to do it before 8.2 iirc. And it still works. Nevertheless I'll look into it.
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: 答复: [ADMIN] sql to grant privilege on sequence
In-Reply-To: <020f01cf9f46$5fff2ec0$1ffd8c40$@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