creating a createuserfunction.

From: Michael Weaver <mweaver(at)corpusglobe(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: creating a createuserfunction.
Date: 2003-02-25 08:04:16
Message-ID: 3B663B41B350D311AEEF00A0C9254563201A7D@VISION1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I need a function to create a user that can be used from an unpriviledged
user account.
I was hoping to encapsulate the call to create a user in a function and the
allow access to that function.

The problem I had with just giving the user createuser priviledges was that
as soon as the user can create a user they become a superuser. - which is
bad.

Any ideas?

,

Mike Weaver
Software Developer

5, 42 Ladner Street
O'Connor, WA, 6163
All correspondence:
PO Box Y3502
East St Georges Terrace
Perth WA 6832

P: (+618) 9331 2700
F: (+618) 9331 3733
M: 0403 385 181
W: http://www.corpusglobe.com/
E: mweaver(at)corpusglobe(dot)com

This email is intended only for the use of the individual or entity named
above and may contain information that is confidential. If you are not the
intended recipient, you are hereby notified that any dissemination,
distribution or copying of this email is strictly prohibited. When addressed
to our clients, any opinions or advice contained in this email are subject
to the terms and conditions expressed in the governing Corpus Globe client
engagement letter. If you have received this Email in error, please notify
us immediately by return email or telephone +61 8 9331 2700 and destroy the
original message. Thank You.

Browse pgsql-novice by date

  From Date Subject
Next Message Adam Witney 2003-02-25 17:22:49 Re: User Problem In PostgreSQL on Mac OS X
Previous Message Robert Prather 2003-02-24 22:44:59 Re: User Problem In PostgreSQL on Mac OS X