Re: catalog view use to find DATABASE, LANGUAGE, TABLESPACE, SCHEMA, SEQUENCE privileges granted to user or role

Tom,

This sound pretty ugly.  Are you saying that there is no way I can
select all the rows for views in the information_schema, unless I am the
database owner or superuser? in the server?  I can't just grant a user
some type of system view privileges to override this feature like other
database type?

So if I need to find out what table, view and function are granted to
user or role.  I should be force to use pg_class and pg_proc?  Unless I
can have superuser access?


Thanks,
Louis.

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Wednesday, June 03, 2009 2:15 PM
To: Louis Lam
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] catalog view use to find DATABASE, LANGUAGE,
TABLESPACE, SCHEMA, SEQUENCE privileges granted to user or role

"Louis Lam" <louis.lam@guardium.com> writes:
> Since you know this are well.  Do you know if there is some kind of
> records filtering use by PostgreSQL when selecting system objects?
For
> example, I run this query by PostgreSQL user.

> select count(*) from information_schema.table_privileges;

The information_schema views filter out information about objects that
you don't have any privileges for.  This is required by SQL spec.
It's a bit pointless, since anybody can look at the underlying catalogs,
but we make them follow spec anyway.

            regards, tom lane