• Tom Lane's avatar
    Doc: clarify behavior of ALTER DEFAULT PRIVILEGES ... IN SCHEMA. · 787b3fd3
    Tom Lane authored
    The existing text stated that "Default privileges that are specified
    per-schema are added to whatever the global default privileges are for
    the particular object type".  However, that bare-bones observation is
    not quite clear enough, as demonstrated by the complaint in bug #16124.
    Flesh it out by stating explicitly that you can't revoke built-in
    default privileges this way, and by providing an example to drive
    the point home.
    
    Back-patch to all supported branches, since it's been like this
    from the beginning.
    
    Discussion: https://postgr.es/m/16124-423d8ee4358421bc@postgresql.org
    787b3fd3
alter_default_privileges.sgml 9.11 KB