Re: Inconsistent permission enforcement for schemas

2022-08-01 Thread Tom Lane
=?UTF-8?Q?Marcin_Barczy=C5=84ski?= writes: > Why can a user access a table from a forbidden schema if the table is > explicitly specified in the definition of a view in an allowed schema? And > not if the table is accessed by a function used in the view. (1) Whether a view can access a table is d

Inconsistent permission enforcement for schemas

2022-08-01 Thread Marcin BarczyƄski
Hello, Why can a user access a table from a forbidden schema if the table is explicitly specified in the definition of a view in an allowed schema? And not if the table is accessed by a function used in the view. Example: ``` DROP SCHEMA IF EXISTS forbidden_schema CASCADE; DROP SCHEMA IF EXISTS a