Lists: | pgsql-general |
---|
From: | Weiping <laser(at)qmail(dot)zhengmai(dot)net(dot)cn> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Could we hide the table name listing from unprivileged user? |
Date: | 2004-11-27 14:21:25 |
Message-ID: | 41A88D65.9030907@qmail.zhengmai.net.cn |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
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
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 |
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