Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-sql-owner+M38341=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
 id 1ZUJn9-000239-BN
 for pgsql-sql@arkaria.postgresql.org; Tue, 25 Aug 2015 19:21:55 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.84) (envelope-from
 <pgsql-sql-owner+M38341=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
 id 1ZUJn8-0005I7-9S
 for pgsql-sql@arkaria.postgresql.org; Tue, 25 Aug 2015 19:21:54 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
 by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
 (Exim 4.84) (envelope-from <amreenkhan@hotmail.com>)
 id 1ZUJm8-00048a-S2
 for pgsql-sql@postgresql.org; Tue, 25 Aug 2015 19:20:53 +0000
Received: from col004-omc2s8.hotmail.com ([65.55.34.82])
 by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
 (Exim 4.84) (envelope-from <amreenkhan@hotmail.com>)
 id 1ZUJm1-0003CI-Dt
 for pgsql-sql@postgresql.org; Tue, 25 Aug 2015 19:20:51 +0000
Received: from COL131-W70 ([65.55.34.72]) by COL004-OMC2S8.hotmail.com over
 TLS secured channel with Microsoft SMTPSVC(7.5.7601.23008);
 Tue, 25 Aug 2015 12:20:44 -0700
X-TMN: [0kLxTVYLSjHep8GcfiH10FZxVx9cRojS]
X-Originating-Email: [amreenkhan@hotmail.com]
Message-ID: <COL131-W7012184ADC9FA1DFD7C762D3610@phx.gbl>
Content-Type: multipart/alternative;
 boundary="_06c06bfe-6209-49ae-98cf-b68f19b06ae6_"
From: Amreen Khan <amreenkhan@hotmail.com>
To: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
Subject: Reassign permissions
Date: Tue, 25 Aug 2015 14:20:43 -0500
Importance: Normal
MIME-Version: 1.0
X-OriginalArrivalTime: 25 Aug 2015 19:20:44.0089 (UTC)
 FILETIME=[23532290:01D0DF6B]
X-Pg-Spam-Score: -4.0 (----)
List-Archive: <http://archives.postgresql.org/pgsql-sql>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-sql.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@postgresql.org>
List-Post: <mailto:pgsql-sql@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-sql>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
X-Mailing-List: pgsql-sql
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

--_06c06bfe-6209-49ae-98cf-b68f19b06ae6_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I had a function that a group owns=2C I'm part of this group. I wanted to c=
hange the permissions or give grant delete privileges to session_user. And =
another group of users was granted all privileges on the function in order =
to be able to run it. My group still wants to own the function but we want =
whoever runs the function outside of our group to be able to have delete pr=
ivileges on a table that is created within the function. Does anyone have a=
ny suggestions?

Amreen Khan  		 	   		  =

--_06c06bfe-6209-49ae-98cf-b68f19b06ae6_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<style><!--
.hmmessage P
{
margin:0px=3B
padding:0px
}
body.hmmessage
{
font-size: 12pt=3B
font-family:Calibri
}
--></style></head>
<body class=3D'hmmessage'><div dir=3D'ltr'>I had a function that a group ow=
ns=2C I'm part of this group. I wanted to change the permissions or give gr=
ant delete privileges to session_user. And another group of users was grant=
ed all privileges on the function in order to be able to run it. My group s=
till wants to own the function but we want whoever runs the function outsid=
e of our group to be able to have delete privileges on a table that is crea=
ted within the function. Does anyone have any suggestions?<br><br><font col=
or=3D"#000000" face=3D"Garamond" size=3D"4" style=3D"font-size:16pt=3B"><st=
rong><em>Amreen Khan </em></strong></font> 		 	   		  </div></body>
</html>=

--_06c06bfe-6209-49ae-98cf-b68f19b06ae6_--