pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Peter Elmers <p.elmers@gmx.de>
To: Ben Kim <bkim@tamu.edu>
Cc: pgsql-admin@postgresql.org
Subject: Re: adding a user with the permission to create trimmed users
Date: Tue, 21 Aug 2007 16:17:08 +0200
Message-ID: <9DC874AE-B609-4FCF-B0E8-B055658667AB@gmx.de> (raw)
In-Reply-To: <Pine.GSO.4.64.0708171216250.24598@coe.tamu.edu>
References: <389EEEE3-3B4E-4B0C-B16B-7F61E8EDE76C@gmx.de>
	<Pine.GSO.4.64.0708171216250.24598@coe.tamu.edu>

Hi Ben!

Thanks for your answer! It hits the spot.


Peter

Am 17.08.2007 um 19:28 schrieb Ben Kim:

>> I want to know whether there exist the possibility to create a  
>> user who has the permission to create users with preset limited  
>> permissions.
>>
>> In detail:
>> I do not want that the admin user (a separate limited one for the  
>> customer) is able to create full admin users or adequate ones.
>
> It's likely possible. There might be a better reference but you  
> might want to read this: (Look for Tom Lane's post)
>
> http://archives.devshed.com/forums/databases-124/anyone-know-a- 
> good- opensource-crm-that-actually-installs-with-2217243-2.html
>
> Following his example:
>
>     create or replace function makeuser(text, text) returns void as $$
>     begin  execute 'create role ' || quote_ident($1) || ' login  
> password '
>     || quote_literal($2) ; end$$ language plpgsql security definer;
>
> then you can
>
>  	create role a_group;
>  	grant select,insert,update on a_table to a_group with grant option;
>  	alter group a_group add user a_user;
>
> so a_user can now
>
>         select makeuser('b_user','b_password');
>         grant select on a_table to b_user;
>
>
> There might be a better way though.
>
> If you're on 8.1 and upwards, createrole is not separate from  
> superuser. But it seemed if a user is given createrole, even though  
> he's not given the superuser, s/he can drop other users (who s/he  
> didn't create.) So alter user...createuser may not fit here. Please  
> correct me if I'm wrong.
>
>
> HTH
>
>
> Ben K.
> Developer
> http://benix.tamu.edu




view thread (5+ messages)

Message-ID: <9DC874AE-B609-4FCF-B0E8-B055658667AB@gmx.de>
Permalink:  ../9DC874AE-B609-4FCF-B0E8-B055658667AB@gmx.de/
Also on:    postgresql.org/message-id/9DC874AE-B609-4FCF-B0E8-B055658667AB@gmx.de

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: p.elmers@gmx.de, bkim@tamu.edu
  Subject: Re: adding a user with the permission to create trimmed users
  In-Reply-To: <9DC874AE-B609-4FCF-B0E8-B055658667AB@gmx.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox