Re: [HACKERS] Omission in GRANT documentation

2017-10-12 Thread Laurenz Albe
Tom Lane wrote: >> But types also have the USAGE privilege for PUBLIC by default: > > Yup, that's an oversight. > >> Hence I propose the attached documentation patch. > > Pushed, with a bit of additional wordsmithing. Thanks for taking the time. Yours, Laurenz Albe -- Sent via pgsql-hacker

Re: [HACKERS] Omission in GRANT documentation

2017-10-11 Thread Tom Lane
Laurenz Albe writes: > grant.sgml says that >the default privileges granted to PUBLIC are as follows: CONNECT and >CREATE TEMP TABLE for databases; EXECUTE privilege for functions; >and USAGE privilege for languages. > But types also have the USAGE privilege for PUBLIC by default: Yu

[HACKERS] Omission in GRANT documentation

2017-10-10 Thread Laurenz Albe
grant.sgml says that the default privileges granted to PUBLIC are as follows: CONNECT and CREATE TEMP TABLE for databases; EXECUTE privilege for functions; and USAGE privilege for languages. But types also have the USAGE privilege for PUBLIC by default: test=> CREATE TYPE bug_status A