programmatic interface into admin

From: "SRINIVASARAGHAVAN, RAJESH (HP-Cupertino, ex1)" <rajesh_srinivasaraghavan(at)am(dot)exch(dot)hp(dot)com>
To: "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Cc: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: programmatic interface into admin
Date: 2001-01-03 01:00:29
Message-ID: 87FB8F5CE210D311B60500A0C9F4871C087C6CEA@xcup01.cup.hp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

hi all,
I am trying to programmatically administer postgres. Spefically, interested
in adding new user, deleting an existing user, creating and deleting
databases for a user and modifying user's password. I know that all the
above (except for password modifications) can be done using JDBC calls into
the postgres database and modifying the template1 tables. My questions are

1. Is there a security risk or any downside in interfacing directly with
postgres using jdbc queries and not using the system command line utilities
2. Can I programmatically modify the user's password on the postgres system.
Is the password of the user stored in any other place other than the
password file specified in my data directory. Is it a crypt function that
generates the password and stores it in the password file. The obvious
solution to the problem is to use a series of expects with perl on the
remote system.

thank you for your time.

rajesh

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andrew Snow 2001-01-03 01:35:05 RE: programmatic interface into admin
Previous Message jmoschet 2001-01-02 22:55:30 problem with mkMakefile.tcldefs.sh if USE_TCL=false

Browse pgsql-general by date

  From Date Subject
Next Message Vince Vielhaber 2001-01-03 01:12:17 Re: RE: Re: MySQL and PostgreSQL speed compare
Previous Message eric 2001-01-03 00:55:40 RE: RE: Re: MySQL and PostgreSQL speed compare