Received: from ipfu2.bau-verm.uni-karlsruhe.de (ipfu2.bau-verm.uni-karlsruhe.de [129.13.144.84]) by hub.org (8.9.3/8.9.3) with SMTP id NAA10481 for ; Tue, 22 Jun 1999 13:52:21 -0400 (EDT) (envelope-from renuncio@ipf.uni-karlsruhe.de) Received: from ipf.uni-karlsruhe.de(ipfe6b.bau-verm.uni-karlsruhe.de[129.13.144.82]) (1268 bytes) by ipfu2.bau-verm.uni-karlsruhe.de via sendmail with P:esmtp/R:inet_hosts/T:smtp (sender: ) id for ; Tue, 22 Jun 1999 19:52:11 +0200 (MET DST) (Smail-3.2.0.101 1997-Dec-17 #3 built DST-Jun-8) Message-ID: <376FCCEF.6BC887DD@ipf.uni-karlsruhe.de> Date: Tue, 22 Jun 1999 19:50:39 +0200 From: Luiz Renuncio X-Mailer: Mozilla 4.6 [en] (WinNT; I) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Sharing a user defined type Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit To: pgsql-sql@postgresql.org Subject: Sharing a user defined type Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello, we created a new data type (a 3d point) and the functions to access it. Everything works all right when we log as the DB administrator ( who created type and function). Now we want to share the new existing data type with other users and groups that do not have permission to execute data and function creation. The question is: how can we share new data types with other users than their creator. We have been looking for an answer in the whole pgsql docs, man pages, etc but nothing was found. Does anybody knows the answer? We'd appreciate any help... Thanks L. E. Renuncio