X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 43AE652824
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Wed, 15 Jun 2005 14:06:43 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 48603-04
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Wed, 15 Jun 2005 17:06:37 +0000 (GMT)
Received: from web20828.mail.yahoo.com (web20828.mail.yahoo.com
	[216.136.227.167])
	by svr1.postgresql.org (Postfix) with SMTP id 39EDD52819
	for <pgsql-interfaces@postgresql.org>;
	Wed, 15 Jun 2005 14:06:36 -0300 (ADT)
Received: (qmail 40018 invoked by uid 60001); 15 Jun 2005 17:06:35 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=EZ3PTnRYUi/mTPUuAj0bmDPv0vp29KWteprH6KkURdBGZq7a12vxaoMJjrQdOgjtjgfVuk95pEnbI8G1KaXnc5AsFst1mPTn/YMBqOjD2Jdh+8954MhEohEA/9DEpKCXR2cxXihyU8u7g4vmk4H70gp3pS249auQP5i86V8hHCk=
	;
Message-ID: <20050615170635.40016.qmail@web20828.mail.yahoo.com>
Received: from [24.248.12.141] by web20828.mail.yahoo.com via HTTP;
	Wed, 15 Jun 2005 10:06:35 PDT
Date: Wed, 15 Jun 2005 10:06:35 -0700 (PDT)
From: Jeff Eckermann <jeff_eckermann@yahoo.com>
Subject: Re: users/users groups management from MS Access front-end
To: Zlatko Matic <zlatko.matic1@sb.t-com.hr>, pgsql-interfaces@postgresql.org
In-Reply-To: <015c01c571bf$b14af8e0$d4211dc3@zlatkovyfkpgz6>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=1.071 tagged_above=0 required=5 tests=AWL,
	DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST
X-Spam-Level: *
X-Archive-Number: 200506/45
X-Sequence-Number: 5613

--- Zlatko Matic <zlatko.matic1@sb.t-com.hr> wrote:

> Well, I want to use POstgreSQL user acounts, but
> would like to create new 
> users and put them in predefined groups through
> Access interface, instead of 
> doing it through pgAdmin, for example.

That would just be a matter of creating a user
interface (i.e. a form) to handle the user input, and
issuing appropriate SQL commands.  Maybe the best way,
to preserve security, would be to handle the user
setup via a server function, with appropriate rights
granted to application administrators, who otherwise
are not database superusers.  That would reduce the
opportunity for your backend setup to be compromised
by a user.

> 
> ----- Original Message ----- 
> From: "Jeff Eckermann" <jeff_eckermann@yahoo.com>
> To: "Zlatko Matia" <zlatko.matic1@sb.t-com.hr>; 
> <pgsql-interfaces@postgresql.org>
> Sent: Wednesday, June 15, 2005 5:15 PM
> Subject: Re: [INTERFACES] users/users groups
> management from MS Access 
> front-end
> 
> 
> > --- Zlatko Matiæ <zlatko.matic1@sb.t-com.hr>
> wrote:
> >
> >> Does anyone have some experience with users
> >> management from MS Access front-end ?
> >
> > Is there any reason why you would not want to use
> > PostgreSQL user accounts for this?
> >
> >
> >
> >
> > __________________________________
> > Discover Yahoo!
> > Stay in touch with email, IM, photo sharing and
> more. Check it out!
> > http://discover.yahoo.com/stayintouch.html 
> 
> 



		
__________________________________ 
Discover Yahoo! 
Use Yahoo! to plan a weekend, have fun online and more. Check it out! 
http://discover.yahoo.com/