Re: untrusted PLs should be GRANTable

2018-07-18 Thread Craig Ringer
On 19 July 2018 at 08:23, Stephen Frost wrote: > Greetings, > > * Craig Ringer (cr...@2ndquadrant.com) wrote: > > Untrusted PLs should be GRANTable with a NOTICE or WARNING telling the > > admin that GRANTing an untrusted PL effectively gives the user the > ability &g

Re: untrusted PLs should be GRANTable

2018-07-18 Thread Stephen Frost
Greetings, * Craig Ringer (cr...@2ndquadrant.com) wrote: > Untrusted PLs should be GRANTable with a NOTICE or WARNING telling the > admin that GRANTing an untrusted PL effectively gives the user the ability > to escape to superuser. I don't know that we really want to get into t

Re: untrusted PLs should be GRANTable

2018-07-18 Thread Stephen Frost
Greetings, * Peter Eisentraut (peter.eisentr...@2ndquadrant.com) wrote: > On 17.07.18 07:20, Craig Ringer wrote: > > A user has raised the point that our refusal to GRANT rights to > > untrusted PLs is counterproductive and inconsistent with how we behave > > elsewhere. > > Previous discussion: >

Re: untrusted PLs should be GRANTable

2018-07-18 Thread Robert Haas
ings more secure, we've made them less secure. > > Untrusted PLs should be GRANTable with a NOTICE or WARNING telling the admin > that GRANTing an untrusted PL effectively gives the user the ability to > escape to superuser. +1. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company

Re: untrusted PLs should be GRANTable

2018-07-17 Thread Peter Eisentraut
On 17.07.18 07:20, Craig Ringer wrote: > A user has raised the point that our refusal to GRANT rights to > untrusted PLs is counterproductive and inconsistent with how we behave > elsewhere. Previous discussion: https://www.postgresql.org/message-id/flat/1357905627.24219.6.camel%40vanquo.pezone.ne

untrusted PLs should be GRANTable

2018-07-16 Thread Craig Ringer
s secure. Untrusted PLs should be GRANTable with a NOTICE or WARNING telling the admin that GRANTing an untrusted PL effectively gives the user the ability to escape to superuser. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services