Re: permission to create user

On Jul 17, 2006, at 2:56 AM, Timothy Smith wrote:

> is it possible to give a non super user the ability to create
> another user of a different group?
> i'm looking for a way to assign a special group of admin's just
> enough rights to create other lowbie users without letting them
> bypass all other access restrictions.

You could create a function with the SECURITY DEFINER option which
allows the function to be executed with the privileges of the user
that created it.


http://www.postgresql.org/docs/8.1/interactive/sql-createfunction.html




John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL