Re: Numeric user names - Mailing list pgsql-general

From Lincoln Yeoh
Subject Re: Numeric user names
Date
Msg-id 5.2.1.1.1.20041021001226.0cae6e90@localhost
Whole thread Raw
In response to Re: Numeric user names  (Ed Stoner <ed@whsd.k12.pa.us>)
List 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.


pgsql-general by date:

Previous
From: Dan Pelleg
Date:
Subject: Re: index not used?
Next
From: John Browne
Date:
Subject: Query buffer editing on Win32 version of postgresql?