programmatic interface into admin
От | SRINIVASARAGHAVAN,RAJESH (HP-Cupertino,ex1) |
---|---|
Тема | programmatic interface into admin |
Дата | |
Msg-id | 87FB8F5CE210D311B60500A0C9F4871C087C6CEA@xcup01.cup.hp.com обсуждение исходный текст |
Ответы |
RE: programmatic interface into admin
|
Список | pgsql-admin |
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
В списке pgsql-admin по дате отправления: