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