On Mon, Jul 17, 2006 at 07:54:08AM -0400, John DeSoi wrote: > 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.
Also, if you're using 8.1, then giving certain roles the CREATEROLE attribute might be what you're after. http://www.postgresql.org/docs/8.1/interactive/role-attributes.html -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
