Re: [GENERAL] Grant problem and how to prevent users to execute OS commands?

2012-08-21 Thread Craig Ringer
You appear to have replied directly to me rather than the list, so I've cc'd the list. On 08/21/2012 10:11 PM, Evil wrote: Dear Craig Ringer And Dear Thom! THANK YOU VERY MUCH for such Great and easy explanation! Now everything seems is kk with grants.From now i think i understand how to sep

[GENERAL] Grant problem and how to prevent users to execute OS commands?

2012-08-21 Thread Evil
Hello List, First time here also beginner to Postgres.So please forgive me for any mistakes. I'm pretty sure i have same problem.=> http://archives.postgresql.org/pgsql-admin/2012-03/msg00105.php (After searching it i found it) However it is not solution for me.:( *I'm pretty sure i'm doing somet

Re: [GENERAL] Grant problem and how to prevent users to execute OS commands?

2012-08-20 Thread Thom Brown
On 20 August 2012 19:34, Evil wrote: > Hello List, > First time here also beginner to Postgres.So please forgive me for any > mistakes. > I'm pretty sure i have same problem.=> > http://archives.postgresql.org/pgsql-admin/2012-03/msg00105.php > (After searching it i found it) > However it is not s

Re: [GENERAL] Grant problem and how to prevent users to execute OS commands?

2012-08-20 Thread Craig Ringer
On 08/21/2012 02:34 AM, Evil wrote: After issusing that revoke from public my postgres user still able to connect to any database. Looking at your logs, you tested to see if they could connect to a database named "onlypostgres", but I didn't see any sign that you had REVOKEd connect from publ

Re: [GENERAL] grant problem

2005-03-22 Thread Bruno Wolff III
On Tue, Mar 22, 2005 at 17:47:48 +0530, Rajarshi Mukherjee <[EMAIL PROTECTED]> wrote: > PLEASE GIVE ME AN EXAMPLE.. Please read the documentation of the CREATE FUNCTION command. > > > On Tue, 22 Mar 2005 06:24:58 -0600, Bruno Wolff III <[EMAIL PROTECTED]> wrote: > > On Tue, Mar 22, 2005 at 17

Re: [GENERAL] grant problem

2005-03-22 Thread John DeSoi
On Mar 22, 2005, at 7:17 AM, Rajarshi Mukherjee wrote: PLEASE GIVE ME AN EXAMPLE.. Just add the "SECURITY DEFINER" keyword to the function definition. http://www.postgresql.org/docs/8.0/interactive/sql-createfunction.html John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL

Re: [GENERAL] grant problem

2005-03-22 Thread Richard Huxton
Rajarshi Mukherjee wrote: Hello all, i have a function that updates a table. I gave execute grant on it to a particular user but no grant on the table in question. when logging in as that user and executing the function, i get an error ERROR: permission denied for relation How can i en

Re: [GENERAL] grant problem

2005-03-22 Thread Rajarshi Mukherjee
PLEASE GIVE ME AN EXAMPLE.. On Tue, 22 Mar 2005 06:24:58 -0600, Bruno Wolff III <[EMAIL PROTECTED]> wrote: > On Tue, Mar 22, 2005 at 17:27:25 +0530, > Rajarshi Mukherjee <[EMAIL PROTECTED]> wrote: > > Hello all, > > > > i have a function that updates a table. I gave execute grant on it to > >

Re: [GENERAL] grant problem

2005-03-22 Thread Bruno Wolff III
On Tue, Mar 22, 2005 at 17:27:25 +0530, Rajarshi Mukherjee <[EMAIL PROTECTED]> wrote: > Hello all, > > i have a function that updates a table. I gave execute grant on it to > a particular user but no grant on the table in question. > > when logging in as that user and executing the functi

[GENERAL] grant problem

2005-03-22 Thread Rajarshi Mukherjee
Hello all, i have a function that updates a table. I gave execute grant on it to a particular user but no grant on the table in question. when logging in as that user and executing the function, i get an error ERROR: permission denied for relation How can i ensure that any update on th