From: Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
To: pgsql-admin@postgresql.org
Subject: information_schema.role_table_grants differs from relacl
Date: Wed, 15 Sep 2010 17:55:50 +0200
Message-ID: <20100915155550.202140@gmx.net> (raw)
Hello,
there seems to be a difference between information_schema and pg_catalog when it comes to privileges.
pg_class and pgAdmin III show ACL = arwdDxt
pgAdmin III displays this as:
GRANT ALL ON TABLE blabla.tabelle TO benutzer;
However, information_schema.role_table_grants has is_grantable = YES for every privilege_type on this view for the user in question.
The user is owner of the view and also superuser.
So my question is: is is_grantable not the same as 'WITH GRANT OPTION'?
Could you tell me, please?
Thank you very much,
Peter
P.S. Server version is PostgreSQL 8.4.3 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.3.3 (SuSE Linux), 64-bit
--
GRATIS: Spider-Man 1-3 sowie 300 weitere Videos!
Jetzt freischalten! http://portal.gmx.net/de/go/maxdome
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: Jan-Peter.Seifert@gmx.de
Subject: Re: information_schema.role_table_grants differs from relacl
In-Reply-To: <20100915155550.202140@gmx.net>
* 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