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 JAA25566 for ; Tue, 22 Jun 1999 09:14:37 -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]) (1124 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 15:14:06 +0200 (MET DST) (Smail-3.2.0.101 1997-Dec-17 #3 built DST-Jun-8) Message-ID: <376F8B92.EFE404F5@ipf.uni-karlsruhe.de> Date: Tue, 22 Jun 1999 15:11:46 +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 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