EdVassie,

I've tested the exact situation by running the script of Piotr. This however gives me, just like you said the functionality to enable/disable the viewing of the user tables.

This is however not the functionality i am after!

I'm looking for a way to hide the system and INFORMATION_SCHEMA tables in my odbc connection dialog. I only want to see the user tables. It is simply confusing for the enduser.

My users connect through an ODBC connection by using windows authentication. The windows user is a member of the no_schema_view_role indeed.

Changing the memberschip toggles the visibility of the user tables.

Is this the scenario you talked about, or is there a misunderstaning?

Thanks.