Re: Numeric user names

From: Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>
To: Ed Stoner <ed(at)whsd(dot)k12(dot)pa(dot)us>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Neil Conway <neilc(at)samurai(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Numeric user names
Date: 2004-10-20 16:21:23
Message-ID: 5.2.1.1.1.20041021001226.0cae6e90@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

At 09:25 AM 10/19/2004 -0400, Ed Stoner wrote:

>I want to use bare numbers because that is how the users (students in this
>case) are identified on the network and in the student information
>system. They've been identified this way for over 20 years, so it would
>be near impossible to change at this point (although it is not always very
>convenient :-). I'm trying (and almost finished now) to have the postgres
>server be the source of all user account information on the network
>(windows and linux).

Just curious - but it doesn't seem obvious why you need all postgresql
users == all users in the student information system?

Any reasons why?

Assuming the student information system is an application, I'd have created
a table and each basic user account info would be in its own row in that
table, and link rows from other tables to those rows as necessary.

Or maybe used something like LDAP (and add the necessary glue :( ).

Of course if ALL students need to directly use the same postgresql database
with their own individual accounts then that's probably a good reason.

Regards,

Link.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John Browne 2004-10-20 16:25:19 Query buffer editing on Win32 version of postgresql?
Previous Message Dan Pelleg 2004-10-20 16:14:54 Re: index not used?