Postgres Pro
Downloads
Home   >   mailing lists

Thread: column of table

column of table

From
Henry Francisco Garcia Cortez
Date:
This query Grant select on table (name table) to (name user) but I want to show only a column and rest of column that remain blocked 

--
Ing. Henry G. Cortez



Re: column of table

From
Scott Ribe
Date:
> On Sep 17, 2020, at 5:09 PM, Henry Francisco Garcia Cortez <garcortez@gmail.com> wrote:
>
> This query Grant select on table (name table) to (name user) but I want to show only a column and rest of column that
remainblocked  

You probably want to create a view for this purpose.

Re: column of table

From
Tom Lane
Date:
Henry Francisco Garcia Cortez <garcortez@gmail.com> writes:
> This query Grant select on table (name table) to (name user) but I want to
> show only a column and rest of column that remain blocked

Doesn't a per-column GRANT do what you want?

            regards, tom lane

Re: column of table

From
Henry Francisco Garcia Cortez
Date:
first I'm going to revoke all tables in schema public from public then I want only to show a column of the table

El jue., 17 sept. 2020 a las 20:15, Tom Lane (<tgl@sss.pgh.pa.us>) escribió:
Henry Francisco Garcia Cortez <garcortez@gmail.com> writes:
> This query Grant select on table (name table) to (name user) but I want to
> show only a column and rest of column that remain blocked

Doesn't a per-column GRANT do what you want?

                        regards, tom lane


--
Ing. Henry G. Cortez