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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Weiping <laser(at)qmail(dot)zhengmai(dot)net(dot)cn>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Could we hide the table name listing from unprivileged user?
Date: 2004-11-27 18:21:09
Message-ID: 27042.1101579669@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Weiping <laser(at)qmail(dot)zhengmai(dot)net(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-11-27 18:27:43 Re: Boolean error
Previous Message Tom Lane 2004-11-27 18:14:55 Re: how many JOINs ?