pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Aasmund Midttun Godal <postgresql@envisity.com>
To: pgsql-sql@postgresql.org
Subject: Access to functions
Date: Fri, 19 Oct 2001 01:51:18 GMT
Message-ID: <20011019015118.25128.qmail@ns.krot.org> (raw)

There is currently no functionality to grant or deny access to functions.

I believe anyone can run any function and the function is run as the user who runs it.

This is also the case with views, which is odd, as the rest of the select statement is granted access to a table which the function in the view does not have access to.

Functions triggered seem on the other handed to be 'trusted'. This can obviously be exploited.


I have noticed a trusted field in the pg_proc and pg_language tables, can I use this somehow (I haven't got my hopes up as they are all 't' on pg_proc), ??

I looked through the todo, and albeit being a lot of new features in the grant section I cannot find any info regarding these issues.

Sincerely,

Aasmund.


Aasmund Midttun Godal

aasmund@godal.com - http://www.godal.com/
+47 40 45 20 46



Message-ID: <20011019015118.25128.qmail@ns.krot.org>
Permalink:  ../20011019015118.25128.qmail@ns.krot.org/
Also on:    postgresql.org/message-id/20011019015118.25128.qmail@ns.krot.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: postgresql@envisity.com
  Subject: Re: Access to functions
  In-Reply-To: <20011019015118.25128.qmail@ns.krot.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox