Users and unique identifyers

From: mstory(at)uchicago(dot)edu
To: pgsql-general(at)postgresql(dot)org
Subject: Users and unique identifyers
Date: 2005-01-18 06:35:01
Message-ID: 1106030101.41ecae15138d7@churlish.uchicago.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I need a way to link every user name to a unique ID held in a table in the
database. I've tried several ways of doing this but all of which are not secure
enough. It's essential that no one be able to view the user names, though the
unique identifyers will be viewable to all users on the public schema. My best
bet right now is to store the user names in an encrypted table with a column for
the user name and a column for the id. This method seems to be the most secure.
Am i on the right track here?

many thanks,

matt

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hong Yuan 2005-01-18 06:56:02 Re: Multiline plpython procedure
Previous Message Tom Lane 2005-01-18 06:24:31 Re: Multiline plpython procedure