Re: Schemas permissions vs \dt - Mailing list pgsql-general

From Tom Lane
Subject Re: Schemas permissions vs \dt
Date
Msg-id 23874.1051070850@sss.pgh.pa.us
Whole thread Raw
In response to Schemas permissions vs \dt  (Francisco Reyes <lists@natserv.com>)
Responses Re: Schemas permissions vs \dt  (Francisco Reyes <lists@natserv.com>)
List pgsql-general
Francisco Reyes <lists@natserv.com> writes:
> Is there a way to revoke rights of users so they can not do \dt on other
> people's schemas?

No.  \dt isn't accessing the other peoples' tables, only the system
catalogs, which are necessarily open to all.

            regards, tom lane


pgsql-general by date:

Previous
From: Erik Ronström
Date:
Subject: Getting named fields of NEW
Next
From: Stephan Szabo
Date:
Subject: Re: Left Join Not Using Index?