MAY I HAVE YOUR ASSISTANCE

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.

Responses

Browse pgsql-sql by date

  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"