I also needed to give the privilege to execute pg_terminate_backend to
non-superusers and I made it in a separate schema, too. But, to avoid users
killing other user connections I made another function that only gives the
option to kill connections made by the same user that's executing the
functio
Thanks Guys. I wrote this function in a specific schema and granted to the
dba users only. Thanks. Problem solved.
--
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-tp5618129p
On 2012-04-04, leaf_yxj wrote:
> Hi Aaron: thanks. I tried the security definer. it works well as follows :
>
> CREATE FUNCTION kill_process(integer) RETURNS boolean AS 'select
> pg_cancel_backend($1);' LANGUAGE SQL SECURITY DEFINER;
>
> One more question about this function : if non-super us
On Wed, Apr 4, 2012 at 12:24 PM, leaf_yxj wrote:
> Hi Aaron: thanks. I tried the security definer. it works well as follows :
>
> CREATE FUNCTION kill_process(integer) RETURNS boolean AS 'select
> pg_cancel_backend($1);' LANGUAGE SQL SECURITY DEFINER;
>
> One more question about this function
Hi Aaron: thanks. I tried the security definer. it works well as follows :
CREATE FUNCTION kill_process(integer) RETURNS boolean AS 'select
pg_cancel_backend($1);' LANGUAGE SQL SECURITY DEFINER;
One more question about this function : if non-super user get the
execute this function, he/her w
I've sent this onto the mailng lists...
On Mon, 11 Jan 1999, Jixue Jerry Liu wrote:
> Dear Marc,
>
> My name is Jixue Liu, a PhD student in the School of Computer Science,
> University of South Australia. I am studying view maintenance in OR
> Systems. The model I study most and the system I
