Postgres Pro
Downloads
Home   >   mailing lists

Re: Can user specification of a column value be required when querying a view ? - Mailing list pgsql-general

From Peter J. Holzer
Subject Re: Can user specification of a column value be required when querying a view ?
Date
Msg-id 20231124180056.k4ea6or6clngrkaq@hjp.at
Whole thread Raw
In response to Re: Can user specification of a column value be required when querying a view ?  (Ron Johnson <ronljohnsonjr@gmail.com>)
Responses Re: Can user specification of a column value be required when querying a view ?
List pgsql-general
Tree view 
On 2023-11-20 22:03:06 -0500, Ron Johnson wrote:
> Or row level security.

Does that help here? AIUI row level security can be used to limit access
to specific rows (e.g. user alex can access info about ssn '106-91-9930'
but not '234-56-7890') but not how many rows can be accessed in a single
query.

        hp

--
   _  | Peter J. Holzer    | Story must make more sense than reality.
|_|_) |                    |
| |   | hjp@hjp.at         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"
Attachment

pgsql-general by date:

Previous
From: Les
Date:
Subject: Re: replication primary writting infinite number of WAL files
Next
From: Ron Johnson
Date:
Subject: Re: Can user specification of a column value be required when querying a view ?