Thread: Could we hide the table name listing from unprivileged user?

Hi,
A problem we are facing is although we revoke all from
one database user, he can still see the table exists
in psql using \dt command, but he can'd select * from it
of course, how could we hide the table name listing from
him?

We are using 7.4.x and 8.0 beta, with ODBC, JDBC and libpq.

regards

Laser

Weiping <laser@qmail.zhengmai.net.cn> writes:
> A problem we are facing is although we revoke all from
> one database user, he can still see the table exists
> in psql using \dt command, but he can'd select * from it
> of course, how could we hide the table name listing from
> him?

You can't.  Put him in a different database if that's a problem.

            regards, tom lane