Re: BUG #1150: grant options not properly checked - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #1150: grant options not properly checked
Date
Msg-id 9027.1084282629@sss.pgh.pa.us
Whole thread Raw
In response to BUG #1150: grant options not properly checked  ("PostgreSQL Bugs List" <pgsql-bugs@postgresql.org>)
Responses Re: BUG #1150: grant options not properly checked
List pgsql-bugs
"PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:
> It seems that GRANT ALL ON SCHEMA does not properly
> check for grantor rights.

What's happening is that pg_namespace_aclcheck() allows the operation
if you have GRANT OPTION for *any* of the rights to be granted.  The
same problem exists for all object types.

I am not sure whether we should refuse the operation or just narrow
the set of privileges to those that are grantable per GRANT OPTION.
Peter, any thoughts?

            regards, tom lane

pgsql-bugs by date:

Previous
From: "PostgreSQL Bugs List"
Date:
Subject: BUG #1151: Initdb fails ...
Next
From: Tom Lane
Date:
Subject: Re: BUG #1150: grant options not properly checked