Received: from neptun.sns-felb.debis.de (neptun.sns-felb.debis.de [53.122.101.2]) by postgresql.org (8.11.3/8.11.1) with SMTP id f5B8ffE59472 for ; Mon, 11 Jun 2001 04:41:42 -0400 (EDT) (envelope-from Jens.Hartwig@t-systems.de) Received: by neptun.sns-felb.debis.de; id KAA07256; Mon, 11 Jun 2001 10:41:53 +0200 Received: from unknown(53.47.15.3) by neptun.sns-felb.debis.de via smap (V5.0) id xma007231; Mon, 11 Jun 01 10:41:44 +0200 Received: from mail2000.b3.dsh.de (localhost [127.0.0.1]) by dshmail.dsh.de (8.8.7/8.8.7) with ESMTP id KAA26723 for ; Mon, 11 Jun 2001 10:40:29 +0200 (MET DST) X-MimeOLE: Produced By Microsoft Exchange V6.0.4418.65 content-class: urn:content-classes:message Subject: RE: GRANT EXECUTE Date: Mon, 11 Jun 2001 10:41:15 +0200 Message-ID: <819FEEAC94E6DC459F1FDC83C0C1611F1BCC9F@mail2000.b3.dsh.de> Thread-Topic: [SQL] GRANT EXECUTE Thread-Index: AcDyOrsZNIMdRpVDR6SlZd361GSiEAAFwHpg From: "Hartwig Jens" To: X-Archive-Number: 200106/150 X-Sequence-Number: 3371 Hello all, I fully correspond with the opinion of Dmitry. The ability to grant the privilege to execute a function is very important for productive systems. Especially in the comparison with existing commercial systems like Oracle this missing feature is one of the main disadvantages. Best regards, Jens Hartwig ----------------------------------------------------- T-Systems Project Manager debis Systemhaus GEI GmbH Address: Eichhornstraņe 3, 10785 Berlin Postal Address: 10785 Berlin Phone: (004930) 25 54-32 82 Fax: (004930) 25 54-31 87 Mobile: (0170) 167 26 48 E-Mail: jens.hartwig@t-systems.de Internet: http://www.t-systems.de > -----Ursprungliche Nachricht----- > Von: Dmitry G. Mastrukov [mailto:dmitry@taurussoft.org] > Gesendet: Sonntag, 10. Juni 2001 21:07 > An: pgsql-sql@postgresql.org > Betreff: [SQL] GRANT EXECUTE > > > Hi, All! > > IMHO it will be useful to have EXECUTE privilege on > procedures. It may be > realized through GRANT SELECT ON [procedure] since we cannot directly > execute procedure in SQL. But anyway ability to restrict access to > procedures seems good thing. > > What do you think about it? > > Dmitry > > > ---------------------------(end of > broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html >