Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mZZSP-0002si-PF for pgsql-admin@arkaria.postgresql.org; Sun, 10 Oct 2021 14:05:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mZZSO-0002fk-OC for pgsql-admin@arkaria.postgresql.org; Sun, 10 Oct 2021 14:05:40 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mZZSO-0002fc-66 for pgsql-admin@lists.postgresql.org; Sun, 10 Oct 2021 14:05:40 +0000 Received: from sonic307-9.consmr.mail.ne1.yahoo.com ([66.163.190.32]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mZZSL-0000B4-EX for pgsql-admin@lists.postgresql.org; Sun, 10 Oct 2021 14:05:39 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1633874736; bh=RwYMg4RlCRI6eMJ9N/45yQp032s0a2P5472hip3HFco=; h=Date:From:Reply-To:To:In-Reply-To:References:Subject:From:Subject:Reply-To; b=sAOqHVZk3GOWu6U1rJx8xE8KEWdZ0nZPoYYJgLFazmz9O4YPuO9iY82IuAPLXGawxH47IJoOHvFKq5w6/YCuP7a/6yqtf8HJ1n5LoQ/YzGGqc6nAKFiXm/Jnr4C7FQPANvkKfjdyRTvVj+7Cq58i7p3RJlCmjHQEfLjCzFrrz/zCHu+sH2/KvNRdsNR4IvwWqeQsQeUej/PJQLFWmft2ZshQNQBcHo8AZQwg/uLw+EQdfTp7h07g3WbeJcrGkC/6O85ChKelbr6LoRcZvZvmc1A9PKyWZUMhHgcqzCViOwhZlC72yD1HqVxdvBCIAI0/8JCcaY+hyG3nGdUZV8bP+A== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1633874736; bh=+S2YOOkq/XJcTIIQKlrvF5fETAJIV4l/9rByTx7u+Hd=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=amgMowO9HdEu3luEM2lVaeJRARoBLa017E2zby+cUHESIdcOwVEqhwQbGarSeQSb+f9Brkkxu2fwCTdNIu+bnqyIuj+wjxd350cTciCIaqJCtEzmSTcQmS1X7abgfSmXFQu/rfYAD8hCAc+OH/8/e6VVD9GodcnVqaD9AWuIFguDQjyCH+VOoJgQyZAuIOkrtBDylU/8odTXazjEvfDaQ54jxLagl6RluHj7t3qSP7S2dMXhd3HyBVVtLUh6zl2vUhgL9Qf0AfqEUjTlcDtNvy8iMOoQGrYPf2hmSbls1By5WJw270uyn3LV05z856VoohqMf39tp7d7JcwWQTOfGQ== X-YMail-OSG: KuzxBFwVM1nxIHVBgz.HorZgnM_7OEmv.qWCkqsaoV40wOEO4eieuu5PGj9jdK9 1SVmtxU5NXsDemPVmDioRH36hfHhgV9l1PmdYnKCf4EUoPIay6eE3BAosrlawX0PQYxuga7f.rUX 0crxrQkNkaiEHNhXhcUyKUn3e4gPlILU8cMVid_Y8cQINKyMn2NupG6ORg3w8UT4vamDWCeMG41o 70tjipGXIpoSAEGATn_lDpCJ9ynAGx8lhe8OjddTzUCJP2FgedIwWoHYUoJexgevNPbx9ho8.Ctx tty2Yemq8ST_3_dwP4GE32.xcElWMq_g2nbdDiC10GqCj9zxZEXfhLEsEvY5tD1W95KIoqPtY9hC Fev1ynob6wNxWAzXbIN6neOeDtfzXGyR5TfznX2UFpRz4vXj8C2BijTUn5_3WDYEX7qM.xp2SYhW DEs1AMpgIucJxhlHGXn93DhMuQjmlGYtbDccgpnmfcXGbArJj8MOObWKYUg5CJmlxsbVwr1x9IKU BwJTuz1A5lQLwcasT0hOsIv6sTGyw.ELtELh2Trd4LfOvpCrKJj4ELC722JloGGufjokLR9Xlnmw gfrIhmCkxFfdra0F5Fvjx55pNWf70ih4P34KujFPGl.Oiegjq92MedIkXckAPh.keikRK7ND7eQa X4iF9UVd4nYz08uB4meDQEfGBu0oK1cYz89VyKh9dhOd9zhQoPRUgqSo8z7lbociFxg.VVOovPa8 tuSp6tafqRREiaZSxNlWyqVYagMKcCBiT49aueXocHMNWF2roi3SnZ0o9gj5RMuHUZYU_7md5cZ5 zsA1lyg2QjMcxHsAKPB2ntFOfcd9CNAPAKY.3QOTNU6UD8BxaZQFQZ8vNjgsxxwMJqf4vyuwzTDR gNjvi238AnGPni5io6yzuFycTTg0_HQ7wrEETkiCGG4iS68z4bKevIzaJOBaLFH1DiXfy._Vq7em EjUplqWTSzWcdJkYBxwGNKtaPLv24V2mlLwb1a8USJjPSmLxl3sTEa5JheECFX3hNHpNHRxThQzU NPhYo_gD_XleKKkLCTNKfuN2eDfLoBKIfDqU6VYE7_Ge5pUlyGBvCo9sfVrXDVw4rlXrFSEGDDB4 .Hf96XLxiIjZa6njP4FlARkTwLQC3YawZV9fAOYPcsljpZMSwvCgOWxRiuamURzk5YxrJqrhKoE1 waj.HOki1Mr.6_RNO9Z9aLkiLtyoEUZtnGmFPWdEXpMUO8IW_Mr6DNbOmoKqxmuw6reZILDeXs_E S0fCn73hEU3gyB5tIEExXc5nTxYVkTFSl1rsoThCkMVDFjmRiwBW1xpdiOVdRWbPyBbxZyeiVNgm 9VCixAh5LjjxNsAFf0zcMVdGbi7_AqVIt4zK7RiaULY2WUlKEQJzJda_zXS5e.pVfsOGTe39AdWw 8nAq8Db19UXUInpyHADAoJsWwmmLSLIN3ZzfQbW_Frk5m7j12iCQc6Y3S2H3otk21ZgkME2q9Ay_ xnKoWepLdwWUb0X0b9oDcGlYK66PhmQQuMSaegbl8bARhUoEzvbasuvdYUjUwPEf8cvddF5Gs5D6 2.ouZugbgLitcVYOmcR6WF_No84hAeL91FzjDpgDRKRuL2BXGFSyV1RkeY2zGTVTNc7SOky5prA8 OfHy37OXEpiJW5cZxsvIaS.Rzd5_tZajAahXqLzhHQziDfsd8f1yQwQENaYVqV4u4oF28KCEvClP WyrwFTpw4wNObsGQDryyP.696bIpwjSSIlP2.mkbj9do.j94rDru3rbl9aAWNp3bEgwy5FLXQLa7 z4cL3s8NOf05YaLx0NT1t2I5kKt5qznIZWTpxaOEY.C8LwXAlFCGxJ6Fq1qnF8vWBGOkyv3voZP2 tmAh_2mtKd.MPND1S_ic1q9UoXaYU.7NBCbjhhHudzx6wU.vJsReYpyxiQlWy6x.8IDa0LDisV9Y cAdc2GA4rGJl8nYUDqfLqCSWGyNRR9fC2yaZpAB4sIVHzG6r_4lKdLqPOsJDald0VNCzgKeapdoR Y7Fnm5M7W_51MEVCf9zrKFTcsNyoACa_t0u1Tt49mE11S3Q3a_abc2nQQOLlH.EwVjsufXMOVX0L QUNa5H.DFLa2NlH7e.Z7DNC347zqLQ2uYMd4cYZtmV2cAvAr5x1IW91EFACXFHpZseA_TfTv1Vhz JPFSA_G.bl7PiCbD_xaWws5jhsdg8upb3Z29EZtjsA40dI9pQ_lHNo2OQmoaT026kmL52fh0rwVj I2M2zWFiqKe7XLa0qatVXN4yNUriJhH09oF3kQgIU82KjjP0YhaAK5qpGziCIWfjO9szkoU4xXZV MP8Ti6eDhBS2m4ysjNzKkHpSp X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic307.consmr.mail.ne1.yahoo.com with HTTP; Sun, 10 Oct 2021 14:05:36 +0000 Date: Sun, 10 Oct 2021 14:05:33 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: "pgsql-admin@lists.postgresql.org" , Nelson Gonzaga Message-ID: <1955434795.1515653.1633874733175@mail.yahoo.com> In-Reply-To: <1331401808.1491628.1633855833151@mail.yahoo.com> References: <1331401808.1491628.1633855833151.ref@mail.yahoo.com> <1331401808.1491628.1633855833151@mail.yahoo.com> Subject: Re: Hide function source MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1515652_1430717216.1633874733173" X-Mailer: WebService/1.1.19116 YMailNorrin Content-Length: 6915 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_1515652_1430717216.1633874733173 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable you can grant execute privilege to the user(s)GRANT EXECUTE ON FUNCTION fun= ction_name() TO some_user; Bach-Nga No one in this world is pure and perfect.=C2=A0 If you avoid people for the= ir mistakes you will be alone. So judge less, love, and forgive more.To cal= l him a dog hardly seems to do him justice though in as much as he had four= legs, a tail, and barked, I admit he was, to all outward appearances. But = to those who knew him well, he was a perfect gentleman (Hermione Gingold) **Live simply **Love generously **Care deeply **Speak kindly.*** Genuinely = rich *** Faithful talent *** Sharing success =20 On Sunday, October 10, 2021, 04:52:54 AM EDT, Nelson Gonzaga wrote: =20 =20 Dear,How do I hide a function source code from all users except superuser,= but all can execute it?Thanks,Nelson=C2=A0 =20 ------=_Part_1515652_1430717216.1633874733173 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
you can grant execute privileg= e to the user(s)
GRANT EXECUTE ON FUNCTION functi=
on_name() TO some_user;



=
Bach-Nga

No one in this world is pure and perfe= ct.  If you avoid people for their mistakes you will be alone. So judg= e less, love, and forgive more.3D"Emoji"3D"Emoji"
To call him a dog hardly seems to do h= im justice though in as much as he had four legs, a tail, and barked, I adm= it he was, to all outward appearances. But to those who knew him well, he w= as a perfect gentleman (Hermione Gingold)

**Live simply **Love generously **Care deep= ly **Speak kindly.
*** Genuinely rich *** F= aithful talent *** Sharing success

<= font color=3D"#8000ff" style=3D"background-color: inherit;">


=20
=20
On Sunday, October 10, 2021, 04:52:54 AM EDT, Nelson Go= nzaga <ngonzaga@yahoo.com> wrote:


Dear,
How do I hide a function source co= de from all users except superuser, but all can execute it?
Thanks,
Nelson 
<= /div>
------=_Part_1515652_1430717216.1633874733173--