pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
sql to grant privilege on sequence 2+ messages / 2 participants [nested] [flat]
* sql to grant privilege on sequence @ 2014-07-14 06:16 liuyuanyuan <liuyuanyuangogo@gmail.com> 2014-07-14 08:49 ` Re: sql to grant privilege on sequence Guillaume Lelarge <guillaume@lelarge.info> 0 siblings, 1 reply; 2+ messages in thread From: liuyuanyuan @ 2014-07-14 06:16 UTC (permalink / raw) To: pgsql-admin 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 ? Regards, Yours Jasmine July 14, 2014 Attachments:image005.jpg (image/jpeg, 13.5K) download
view imageimage006.jpg (image/jpeg, 18.2K) download
view imageimage008.jpg (image/jpeg, 12.7K) download
view image^ permalink raw reply [nested|flat] 2+ messages in threadimage012.jpg (image/jpeg, 26.5K) download
view image
* Re: sql to grant privilege on sequence 2014-07-14 06:16 sql to grant privilege on sequence liuyuanyuan <liuyuanyuangogo@gmail.com> @ 2014-07-14 08:49 ` Guillaume Lelarge <guillaume@lelarge.info> 0 siblings, 0 replies; 2+ messages in thread From: Guillaume Lelarge @ 2014-07-14 08:49 UTC (permalink / raw) To: liuyuanyuan <liuyuanyuangogo@gmail.com>; +Cc: pgsql-admin Le 14 juil. 2014 08:20, "liuyuanyuan" <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. ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2014-07-14 08:49 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2014-07-14 06:16 sql to grant privilege on sequence liuyuanyuan <liuyuanyuangogo@gmail.com> 2014-07-14 08:49 ` Guillaume Lelarge <guillaume@lelarge.info>
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