Re: Wanting to learn about pgsql design decision

<div dir="ltr">Thanks Tom and Andrew!<br />This is indeed interesting.<br /><br />Because I have a couple more of these
questions,and I prefer to avoid receiving a RTFM,<br />I'd appreciate if you could help me understand how I can
researchthe answers to these type of questions by myself.<br /><br />The example questions I gave are just some of the
questionsI've tried to search the answer to, using google and searching this mailing list specifically, but I came up
withnothing. Could I perhaps search the commit comments somehow? Or perhaps a different approach to suggest?<br /><br
/>Thanksfor the interesting comments and help!<br /></div><div class="gmail_extra"><br /><div class="gmail_quote">On
Tue,Aug 2, 2016 at 7:43 PM, Andrew Gierth <span dir="ltr"><<a href="mailto:andrew@tao11.riddles.org.uk"
target="_blank">andrew@tao11.riddles.org.uk</a>></span>wrote:<br /><blockquote class="gmail_quote" style="margin:0 0
0.8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">>>>>> "Tom" == Tom Lane <<a
href="mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>>writes:<br /><br />  >> - Why to read from a table, both
ausage permission on the schema<br />  >> and a read access permission on the table is needed?<br /><br
/></span> Tom>Because the SQL standard says so.<br /><br /> You'd think, but in fact it doesn't; the spec (at least
2008and the<br /> 2011 drafts) has no concept of grantable permissions on schemas, and<br /> ties table ownership and
schemaownership together.<br /><br /> (See the definition of <privileges> to see that there's nothing there<br />
forschemas, and the definition of <table definition> for the fact that<br /> it's the schema owner who also owns
thetable and gets the initial<br /> grants on it, and <drop table statement> and <alter table statement>
to<br/> confirm that only the schema owner can alter or drop the table. The<br /> access rules for <table
reference>only require permission on a table<br /> column, no mention of schemas.)<br /><span class="HOEnZb"><font
color="#888888"><br/> --<br /> Andrew (irc:RhodiumToad)<br /></font></span></blockquote></div><br /></div>