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_...@163.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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
