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:t...@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....@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
