I have a wannabe programer that works for me and he my not for long, nagging
me that we should use FoxPro instead of PostgreSQL and Java.
I have tried and tried to explain this to him. I have tried to show him that
FoxPro is not mainstream anymore. He is a pain in my butt. Would anyone like
to point me to a comparison between FoxPro and PostgreSql. I can find
comparisons between DB-2 or Oracle or MySQL and Postgres but not FoxPro. I
can guess why. I hate being a dictator about things like and I have tried to
help him by saying he could do one little internal project in FoxPro but he
can not even get FoxPro to use ODBC to connect to Postgres. I do not care to
learn anymore about ODBC than what I need to hook Openoffice calc to my
database.
By the way this guy does not even know how to do a binary or to decode a BCD
date. When I asked if it FoxPro had a binary shift he told me it had lots of
keyboard funtions :(
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Sean Chittenden
Sent: Monday, March 04, 2002 11:17 PM
To: Chris Bowlby
Cc: pgsql-general@postgresql.org
Subject: Re: [ADMIN] [GENERAL] password change...
> Hmmm hi all,
>
> Alright I've GOT to be blind (knowing me it's a good possibility)... but
> I have a need to allow postgresql users to be able to change their own
> password, but if they don't have access to the pg_shadow or update user
> command how to I grant them this privilage and/or what command would
> they run....?
$ psql -q template1
template1=# \h ALTER USER
Command: ALTER USER
Description: change a database user account
Syntax:
ALTER USER username [ [ WITH ] option [ ... ] ]
where option can be:
[ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password'
| CREATEDB | NOCREATEDB
| CREATEUSER | NOCREATEUSER
| VALID UNTIL 'abstime'
--
Sean Chittenden
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster