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@xxxxxxxxxxxxx] Sent: Wednesday, June 03, 2009 2:15 PM To: Louis Lam Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: catalog view use to find DATABASE, LANGUAGE, TABLESPACE, SCHEMA, SEQUENCE privileges granted to user or role "Louis Lam" <louis.lam@xxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
