Re: How to create c language in postgresql database. Thanks. - Mailing list pgsql-general

From Chris Travers
Subject Re: How to create c language in postgresql database. Thanks.
Date
Msg-id CAKt_ZftepCvz7FTDcveoUm04QqV1ki6XM2__UwNK2fDpA306jw@mail.gmail.com
Whole thread Raw
In response to Re: How to create c language in postgresql database. Thanks.  (John R Pierce <pierce@hogranch.com>)
Responses Re: How to create c language in postgresql database. Thanks.
List pgsql-general
On Tue, Jun 12, 2012 at 11:47 AM, John R Pierce <pierce@hogranch.com> wrote:
> On 06/12/12 11:25 AM, leaf_yxj wrote:
>>
>> Thanks. You guys are right. I check the database. The C programm is there.
>>   ----- but why our application team keep ask me to give them the superuser
>> privileges to create the C function. Should they use the superuser to create
>> the C function. if yes , why they need it?
>
>
> yes, only a sql superuser can define a C function, as these have total
> access to crashing postgres's innards.
>
Not just the innards, but the file system (could be used to overwrite
data files), arbitrary system commands, etc......

Best Wishes,
Chris Travers

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: How to create c language in postgresql database. Thanks.
Next
From: "Divyaprakash Y"
Date:
Subject: Create view is not accepting the parameter in postgres functions