Lucene search

K
freebsdFreeBSD4B636F50-F011-11ED-BBAE-6CC21735F730
HistoryMay 11, 2023 - 12:00 a.m.

postgresql-server -- Row security policies disregard user ID changes after inlining

2023-05-1100:00:00
vuxml.freebsd.org
18
postgresql
security issue
row security
user id changes
policy
function inlining
cve-2016-2193
interaction
role-specific
security definer
create policy

5 Medium

CVSS2

Attack Vector

NETWORK

Attack Complexity

LOW

Authentication

NONE

Confidentiality Impact

NONE

Integrity Impact

PARTIAL

Availability Impact

NONE

AV:N/AC:L/Au:N/C:N/I:P/A:N

5.4 Medium

CVSS3

Attack Vector

NETWORK

Attack Complexity

LOW

Privileges Required

LOW

User Interaction

NONE

Scope

UNCHANGED

Confidentiality Impact

LOW

Integrity Impact

LOW

Availability Impact

NONE

CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:L/A:N

0.002 Low

EPSS

Percentile

62.0%

PostgreSQL Project reports

    While CVE-2016-2193 fixed most interaction between row security and
    user ID changes, it missed a scenario involving function
    inlining. This leads to potentially incorrect policies being
    applied in cases where role-specific policies are used and a
    given query is planned under one role and then executed under
    other roles. This scenario can happen under security definer
    functions or when a common user and query is planned
    initially and then re-used across multiple SET ROLEs.
    Applying an incorrect policy may permit a user to complete
    otherwise-forbidden reads and modifications. This affects
    only databases that have used CREATE POLICY to define a row
    security policy.
OSVersionArchitecturePackageVersionFilename
FreeBSDanynoarchpostgresql-server< 15.3UNKNOWN

5 Medium

CVSS2

Attack Vector

NETWORK

Attack Complexity

LOW

Authentication

NONE

Confidentiality Impact

NONE

Integrity Impact

PARTIAL

Availability Impact

NONE

AV:N/AC:L/Au:N/C:N/I:P/A:N

5.4 Medium

CVSS3

Attack Vector

NETWORK

Attack Complexity

LOW

Privileges Required

LOW

User Interaction

NONE

Scope

UNCHANGED

Confidentiality Impact

LOW

Integrity Impact

LOW

Availability Impact

NONE

CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:L/I:L/A:N

0.002 Low

EPSS

Percentile

62.0%