Re: Hide some tables

From: Jayadevan M <maymala(dot)jayadevan(at)gmail(dot)com>
To: intmail01(at)gmail(dot)com
Cc: pgsql-sql(at)lists(dot)postgresql(dot)org
Subject: Re: Hide some tables
Date: 2021-08-09 13:39:47
Message-ID: CAFS1N4j8tEDap7sEeZDsQPSCbrFZwjbRYmyTAYPBA+yMP+2_CA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

There are some operators who enters data in my database with just one
> table. Others tables are updated by triggers, these tables contains
> result of calculation. How to do to hide these tables because I do not
> want that operators read them ? On help documentation it is said that I
> can not block SELECT privilege because it is required for UPDATE.
>
Can you move them to a different schema, and manage using search_path?
Regards,
Jayadevan

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2021-08-09 13:45:57 Re: Hide some tables
Previous Message intmail01@gmail.com 2021-08-09 12:57:01 Hide some tables