Postgres Pro
Downloads
Home   >   mailing lists

Thread: schema postgresql

schema postgresql

From
Henry Francisco Garcia Cortez
Date:
how to restrict a user from seeing a schema in postgresql

--
Ing. Henry G. Cortez



Re: schema postgresql

From
Paul Förster
Date:
Hi Henry,

> On 11. Sep, 2020, at 23:13, Henry Francisco Garcia Cortez <garcortez@gmail.com> wrote:
>
> how to restrict a user from seeing a schema in postgresql

for example:

revoke all privileges on <schema> from <user>;

See:
https://www.postgresql.org/docs/current/sql-revoke.html

Cheers,
Paul