"with grant option" for user groups. - Mailing list pgsql-hackers

<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Hi all, </span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">We are building security system for a project where the security is modeled based on the sql-92
GRANT/REVOKEstatements.</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial">I was going through the documentation of postgresql related to GRANT/REVOKE
statements.</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Following statement says that "with grant option" is not allowed to a user group. I would like to
knowwhat the reasons behind not implementing</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">this kind of feature.</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font color="black" face="Times New Roman" size="3"><span
style="font-size:12.0pt;color:black">If</span></font><tt><font color="black" face="Courier New" size="2"><span
style="font-size:10.0pt;color:black">WITHGRANT OPTION</span></font></tt><font color="black"><span style="color:black">
isspecified, the recipient of the privilege may in turn grant it to others. By default this is not allowed. Grant
optionscan only be granted to individual users, not to groups or </span></font><tt><font color="black" face="Courier
New"size="2"><span style="font-size:10.0pt;color:black">PUBLIC</span></font></tt><font color="black"><span
style="color:black">.</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial"><a
href="http://developer.postgresql.org/docs/postgres/sql-grant.html">http://developer.postgresql.org/docs/postgres/sql-grant.html</a></span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">I looked into ORACLE database also they don't support user groups, but they support roles. But even
forroles "with grant option" is not allowed.</span></font><p class="MsoNormal"><font face="Times New Roman"
size="3"><spanstyle="font-size: 
12.0pt"> </span></font><p class="MsoNormal"><font face="Times New Roman" size="3"><span style="font-size:
12.0pt">Thanks & regards,</span></font><p class="MsoNormal"><font face="Times New Roman" size="3"><span
style="font-size:
12.0pt">Ramu</span></font></div>