Could we hide the table name listing from unprivileged user?
Started by Weipingover 21 years ago2 messagesgeneral
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
Re: Could we hide the table name listing from unprivileged user?
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