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 | [EMAIL PROTECTED]&&^*8
0003 | IT-MANAGER | ^8Y3U(-43873GDG?
I appriciate for your assistance in advance,
Sincerely yours,
James Kitambara,
PostgreSQL user.