John schrieb: > Larry has started a discussion regarding the removal of > the "pg_table_is_visible" function from the SQL statement. By removing it > all users are able to see the tables and retrieve field names. Even if the > users search path does not include the schema. By including the statement > the getFields method will return nothing if the search path does not include > the schema. > > Note change the search path as follows: > ALTER USER test SET search_path TO schema1,schema2 > > I always want the field names to be available because it has nothing to > permissions to write or read. The getTables method handles the issue > regarding access - so I see no reason to prevent reading the column > properties. > > On the other hand I'm open to discussion on the matter. For now I'm leaving > the statement out of the SQL string.
The pg_table_is_visible call is not there primarily to control access, but to make sure that only *one* table is selected (and the right one) if there are tables with the same name in different schemas. However, John is right that the check should be removed in the case when the schema is explicitly specified. It should be fixed now in r5502. -- Christoph _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev Searchable Archives: http://leafe.com/archives/search/dabo-dev This message: http://leafe.com/archives/byMID/[email protected]
