Question re security access - dynamic website

Hi,

I need some advice from the much more technically savvy than I.

I'm working on a project with IT staff to develop a relational database
that will result in a database-driven Cal in the Community website
<http://calinthecommunity.berkeley.edu> CIC is an online resource guide to
campus public service programs and resources for the public.

I have fairly recent data culled from a survey that will be imported into
the database.

I want public service programs to be able to input their own data, e.g.,
new programs and updates. Content would be published to the website only
after my approval. The data being collected is not confidential.

I know I want CalNet password protection in order for someone to input
data. My understanding is that I have two choices here:

1) A CalNet ID becomes associated with a particular program
2) Your CalNet ID would enable you to see all programs

Is it a no-brainer that the security level should be choice #1? Even if
it's not confidential data, is #2 just too risky? My concern about #1 is
turnover of people who would input data, especially among the
student-organized public service programs. I don't know the differences in
complexity to program these two choices or what it would mean for me, as
administrator/approver to operate under choice #1. BTW - the database has
about 200 records.

Thanks in advance for your thoughts.

Glenda

THE OFFICE OF COMMUNITY RELATIONS HAS MOVED. PLEASE NOTE NEW MAILING
ADDRESS AND FAX NUMBER

Glenda Rubin
Manager, Community Relations
Government and Community Relations
University of California, Berkeley
336 Sproul Hall
Berkeley, CA 94720-4208
Tel: 510-642-7860
Fax: 510-643-0281
http://communityrelations.berkeley.edu

-----------------------------------------------------------------------
The following was automatically added to this message by the list server:

Webnet information is available at http://webnet.berkeley.edu. Email sent to this list is archived at http://ls.berkeley.edu/mail/webnet/ . This archive is open to the general public and browsable by search engine spiders, email-address harvesting robots, your bosses, etc.
Received on Thu Sep 21 13:32:11 2006