Re: GRANT ON C

From: Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar>
To: Doug McNaught <doug(at)mcnaught(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: GRANT ON C
Date: 2003-12-07 20:13:32
Message-ID: 200312071713.32183.martin@bugs.unl.edu.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

El Dom 07 Dic 2003 17:10, Doug McNaught escribió:
> Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar> 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 only have to
> do that once for each database...

OK.
It's how I thought it was, but need confirmation. ;-)

--
select 'mmarques' || '@' || 'unl.edu.ar' AS email;
-----------------------------------------------------------------
Martín Marqués | mmarques(at)unl(dot)edu(dot)ar
Programador, Administrador, DBA | Centro de Telemática
Universidad Nacional
del Litoral
-----------------------------------------------------------------

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Oliver Elphick 2003-12-07 20:14:57 Re: user defined variable per session
Previous Message Doug McNaught 2003-12-07 20:10:01 Re: GRANT ON C