Re: [GENERAL] GRANT ON C

2003-12-07 Thread Tom Lane
Martin Marques <[EMAIL PROTECTED]> writes: > Is the postgres super-user the only one that can create functions with > LANGUAGE C? Yes. Since there's no way to constrain what a C function does, it would be silly to imagine that a non-superuser wouldn't own the database if he could create C functio

Re: [GENERAL] GRANT ON C

2003-12-07 Thread Doug McNaught
Martin Marques <[EMAIL PROTECTED]> writes: > Is the postgres super-user the only one that can create functions > with LANGUAGE C? Yes, because a C function can basically do anything it wants to with the privileges of the 'postgres' user. So you have to create the function as superuser, but you o

Re: [GENERAL] GRANT ON C

2003-12-07 Thread Oliver Elphick
On Sun, 2003-12-07 at 20:00, Martin Marques wrote: > I'm trying to load the pgcypto.sql file from the contrib in a database and > I've hit a problem which I never had in the past (maybe never did it this > way): when I try to load this file (psql -f) with a specific user, which is > not the post

Re: [GENERAL] GRANT ON C

2003-12-07 Thread Martin Marques
El Dom 07 Dic 2003 17:10, Doug McNaught escribió: > Martin Marques <[EMAIL PROTECTED]> writes: > > > Is the postgres super-user the only one that can create functions > > with LANGUAGE C? > > Yes, because a C function can basically do anything it wants to with > the privileges of the 'postgres' u