Is it now acceptable to use column privileges for system catalogs? For
the new SQL/MED catalogs we have used the old system of revoking all
permissions and having a filtered view on top of it (tradition since
pg_shadow), but I figured we could do this properly now by just revoking
permissions
Peter Eisentraut escreveu:
Is it now acceptable to use column privileges for system catalogs? For
the new SQL/MED catalogs we have used the old system of revoking all
permissions and having a filtered view on top of it (tradition since
pg_shadow), but I figured we could do this properly now
Peter Eisentraut pete...@gmx.net writes:
Is it now acceptable to use column privileges for system catalogs?
Sure, to the same extent that table privileges work for them (ie,
don't expect the C code to pay any attention ;)).
For
the new SQL/MED catalogs we have used the old system of revoking
* Tom Lane (t...@sss.pgh.pa.us) wrote:
I don't have any objection to changing the catalog's own permissions
that way, but the filtered view still has a usability advantage: you
can just go select * from Is it reasonable to change the catalog
permissions and keep the view too?
I've fine