From: | Aaron <aaron(at)chasingnuts(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | leaf_yxj <leaf_yxj(at)163(dot)com> |
Subject: | Re: Questions of the privileges to use the pg_cancel_backend and pg_terminate_backend function. Thanks. |
Date: | 2012-04-04 16:07:34 |
Message-ID: | CAK=0PGM1yQwJNaQNspOpYzyzJDazFjqWd73MZLSk2KN2b_Y6KQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
When I need to give other users access to a function that someone must
be superuser to execute I write a security definer function.
See: http://www.postgresql.org/docs/9.1/static/sql-createfunction.html
Also: http://www.ibm.com/developerworks/opensource/library/os-postgresecurity/index.html
Using the security definer
Think if is like sudo for a db.
Aaron Thul
http://www.chasingnuts.com
On Wed, Apr 4, 2012 at 8:39 AM, leaf_yxj <leaf_yxj(at)163(dot)com> wrote:
> Hi Guys. I got one problem. I need to give some of the non-super users( kind
> of dba) to get the privileges
> to can cancel other users's query, DML. After I granted the execute on
> pg_cancel_backend and pg_terminate_backend function to them, they still get
> the error message as follows when they call these two function :
>
> ERROR : must be superuser to signal other server processes.
>
> QUestion : is it possible to make the non superuser to have these two
> privileges??
>
> Thanks.
>
> Regards.
>
> Grace
>
> --
> View this message in context: http://postgresql.1045698.n5.nabble.com/Questions-of-the-privileges-to-use-the-pg-cancel-backend-and-pg-terminate-backend-function-Thanks-tp5618129p5618129.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Kellerer | 2012-04-04 16:22:06 | Re: views, queries, and locks |
Previous Message | Jon Nelson | 2012-04-04 15:58:50 | Re: views, queries, and locks |