Users and unique identifyers - Mailing list pgsql-general

From mstory@uchicago.edu
Subject Users and unique identifyers
Date
Msg-id 1106030101.41ecae15138d7@churlish.uchicago.edu
Whole thread Raw
Responses Re: Users and unique identifyers  (Michael Fuhr <mike@fuhr.org>)
List 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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Multiline plpython procedure
Next
From: Tino Wildenhain
Date:
Subject: Re: ext3