Re: CREATE OPERATOR query

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Robins Tharakan <tharakan(at)gmail(dot)com>
Cc: pgsql-docs(at)postgresql(dot)org
Subject: Re: CREATE OPERATOR query
Date: 2013-05-22 03:33:50
Message-ID: 20130522033350.GB15045@eldon.alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

Robins Tharakan escribió:
> Yes, but the documentation states that EXECUTE permission for the function
> is required to even CREATE the operator.

What I mean is that your new role still has said permission through
PUBLIC (a pseudo-role which is automatically granted to all other roles
and cannot be revoked), even if you revoke it directly.

--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Peter Eisentraut 2013-05-22 03:38:01 moving documentation to XML
Previous Message Robins Tharakan 2013-05-22 02:03:57 Re: CREATE OPERATOR query