Postgres Pro
Downloads
Home   >   mailing lists

Thread: users/users groups management from MS Access front-end

users/users groups management from MS Access front-end

From
Zlatko Matić
Date:
Does anyone have some experience with users management from MS Access front-end ?

Re: users/users groups management from MS Access front-end

From
Jeff Eckermann
Date:
--- 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

Re: users/users groups management from MS Access front-end

From
"Zlatko Matic"
Date:
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.

----- 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

Re: users/users groups management from MS Access front-end

From
Jeff Eckermann
Date:
--- 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/