From: | James Kitambara <jameskitambara(at)yahoo(dot)co(dot)uk> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | MAY I HAVE YOUR ASSISTANCE |
Date: | 2008-09-01 07:03:51 |
Message-ID: | 931758.39185.qm@web27904.mail.ukl.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Please members of the PGSQL-SQL,
I have one problem with the user table. I want to hide the password for the users.
The table format is:
user ( user_id, user_name, password)
But I want the password to be encrypted so that when other users send the query:SELECT * FROM USER; The password must be gabbage.
i.e. THE OUTPUT SHOULG LOOK LIKE THIS
user_id | user_name | password
-------------------------------------------------------------
0001 | ADMIN | %3g4767teghh890)*
0002 | USER | #42(at)rwfs%6&&^*8
0003 | IT-MANAGER | ^8Y3U(-43873GDG?
I appriciate for your assistance in advance,
Sincerely yours,
James Kitambara,
PostgreSQL user.
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2008-09-01 07:28:36 | Re: MAY I HAVE YOUR ASSISTANCE |
Previous Message | Martin Marques | 2008-08-31 23:19:52 | Re: pg_dump and "could not identify an ordering operator for type name" |