Hiding the Information_Schema from ODBC users.

Hello All....
I'm working on a project in which we are converting a small Oracle DB over
to Postgres. We have several users accessing the data in MS Access,
using ODBC. We have successfully set up the clients with ODBC, and
can access the necessary tables ok, but we have been asked to simplify
things, by not showing the inforamtion_schema tables. I have been
searching around and have not been able to find any definitive
instructions for how this can be accomplished. Is that because as
the driver is currently written there is no option to hide these tables or
have I missed something? I have been playing around with various
roles, and views etc, and have not found any way to do it. Any help
greatly appreciated!

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Re: Hiding the Information_Schema from ODBC users.

francis.brown@agfa.com wrote:
> Hello All....
> I'm working on a project in which we are converting a small Oracle DB over
> to Postgres. We have several users accessing the data in MS Access,
> using ODBC. We have successfully set up the clients with ODBC, and
> can access the necessary tables ok, but we have been asked to simplify
> things, by not showing the inforamtion_schema tables. I have been
> searching around and have not been able to find any definitive
> instructions for how this can be accomplished. Is that because as
> the driver is currently written there is no option to hide these tables or
> have I missed something? I have been playing around with various
> roles, and views etc, and have not found any way to do it. Any help
> greatly appreciated!
>

Please tyr the snapshot driver at
http://www.geocities.jp/inocchichichi/psqlodbc/index.html .

regards,
Hiroshi Inoue


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq