Re: Hide some tables - Mailing list pgsql-sql

From Jayadevan M
Subject Re: Hide some tables
Date
Msg-id CAFS1N4j8tEDap7sEeZDsQPSCbrFZwjbRYmyTAYPBA+yMP+2_CA@mail.gmail.com
Whole thread Raw
In response to Hide some tables  ("intmail01@gmail.com" <intmail01@gmail.com>)
Responses Re: Hide some tables
List 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

pgsql-sql by date:

Previous
From: "intmail01@gmail.com"
Date:
Subject: Hide some tables
Next
From: Tom Lane
Date:
Subject: Re: Hide some tables