pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedhi i need to encrypt one field in a table
3+ messages / 3 participants
[nested] [flat]
* hi i need to encrypt one field in a table
@ 2006-05-30 10:12 Penchalaiah P. <penchalaiahp@infics.com>
0 siblings, 2 replies; 3+ messages in thread
From: Penchalaiah P. @ 2006-05-30 10:12 UTC (permalink / raw)
To: pgsql-sql
Hello,
I want to create a table with an encrypted field for a password entry,
so
that you can see only ********.
And can I encrypt fields which datatype is an integer or a timestamp?
Hi pls let me know this...........
Thanks & Regards
Penchal reddy | Software Engineer
Infinite Computer Solutions | Exciting Times...Infinite Possibilities...
SEI-CMMI level 5 | ISO 9001:2000
IT SERVICES | BPO
Telecom | Finance | Healthcare | Manufacturing | Energy & Utilities |
Retail & Distribution | Government
Tel +91-80-5193-0000(Ext:503)| Fax +91-80-51930009 | Cell No
+91-9980012376|www.infics.com
Information transmitted by this e-mail is proprietary to Infinite
Computer Solutions and/ or its Customers and is intended for use only by
the individual or entity to which it is addressed, and may contain
information that is privileged, confidential or exempt from disclosure
under applicable law. If you are not the intended recipient or it
appears that this mail has been forwarded to you without proper
authority, you are notified that any use or dissemination of this
information in any manner is strictly prohibited. In such cases, please
notify us immediately at info.in@infics.com and delete this mail from
your records.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: hi i need to encrypt one field in a table
@ 2006-05-30 10:14 Juris <bubliks@gmail.com>
parent: Penchalaiah P. <penchalaiahp@infics.com>
1 sibling, 0 replies; 3+ messages in thread
From: Juris @ 2006-05-30 10:14 UTC (permalink / raw)
To: pgsql-sql
For SQL-passwords usually use hashes...
2006/5/30, Penchalaiah P. <penchalaiahp@infics.com>:
>
>
> Hello,
> I want to create a table with an encrypted field for a password entry, so
> that you can see only ********.
> And can I encrypt fields which datatype is an integer or a timestamp?
>
>
>
> Hi pls let me know this………..
>
>
>
> Thanks & Regards
>
> Penchal reddy | Software Engineer
>
> Infinite Computer Solutions | Exciting Times…Infinite Possibilities...
>
> SEI-CMMI level 5 | ISO 9001:2000
>
> IT SERVICES | BPO
>
>
>
>
> Telecom | Finance | Healthcare | Manufacturing | Energy & Utilities | Retail
> & Distribution | Government
>
>
> Tel +91-80-5193-0000(Ext:503)| Fax +91-80-51930009 | Cell No
> +91-9980012376|www.infics.com
>
> Information transmitted by this e-mail is proprietary to Infinite Computer
> Solutions and/ or its Customers and is intended for use only by the
> individual or entity to which it is addressed, and may contain information
> that is privileged, confidential or exempt from disclosure under applicable
> law. If you are not the intended recipient or it appears that this mail has
> been forwarded to you without proper authority, you are notified that any
> use or dissemination of this information in any manner is strictly
> prohibited. In such cases, please notify us immediately at
> info.in@infics.com and delete this mail from your records.
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: hi i need to encrypt one field in a table
@ 2006-05-30 15:09 Mario Splivalo <mario.splivalo@mobart.hr>
parent: Penchalaiah P. <penchalaiahp@infics.com>
1 sibling, 0 replies; 3+ messages in thread
From: Mario Splivalo @ 2006-05-30 15:09 UTC (permalink / raw)
To: pgsql-sql; +Cc: Penchalaiah P. <penchalaiahp@infics.com>
On Tue, 2006-05-30 at 15:42 +0530, Penchalaiah P. wrote:
> Hello,
> I want to create a table with an encrypted field for a password entry, so
> that you can see only ********.
> And can I encrypt fields which datatype is an integer or a timestamp?
No can do. I mean, you can't do something like that. You can either give
(actually, revoke) that particular user/role permisions to read the
table with the passwords, or you could store hashed values to the
database.
Later is prefered, I'd say. You could use md5() function to create
hashes, store those in the database, and when checking for the
credentials compare the hases. You'd compare user input flushed trough
md5() function with the hash you have in the database. That way you
don't know what user passwords are, and you could only set a new
password if user forgets his/hers password.
You don't need encrypted passwords.
Mario
--
Mario Splivalo
Mob-Art
mario.splivalo@mobart.hr
"I can do it quick, I can do it cheap, I can do it well. Pick any two."
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2006-05-30 15:09 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-05-30 10:12 hi i need to encrypt one field in a table Penchalaiah P. <penchalaiahp@infics.com>
2006-05-30 10:14 ` Juris <bubliks@gmail.com>
2006-05-30 15:09 ` Mario Splivalo <mario.splivalo@mobart.hr>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox