separate mysql "sections"?

I am a php/mySQL newbie and I wonder if someone could give some advice:



- my final aim is to build a database to which quite a large group of
different co-workers should have access.

- I would like to use some system of authentication / individual passwords

- Each co-worker should have the opportunity to add data. However (here's
the snag) as far as changing data in the db is concerned, each co-worker
should only have the possibility to change the data that HE HIMSELF entered
earlier. So data entered by others should be shielded off.



Does anyone have any suggestions how I should tackle this problem?

Or does anyone know links to sites where this matter is described in
comprehensible newbie-terms?

Or - even more ideal - does anyone know about scripts that work in this way?



Thanks a lot in advance for thinking about my question,



Herbert

Re: separate mysql "sections"?

Herbert Monch wrote:
[snip]
> - Each co-worker should have the opportunity to add data. However (here's
> the snag) as far as changing data in the db is concerned, each co-worker
> should only have the possibility to change the data that HE HIMSELF entered
> earlier. So data entered by others should be shielded off.
>
> Does anyone have any suggestions how I should tackle this problem?
>

well I would think you will have to record the user ID somewhere in the
table(s) in question so you know who was the originating user. Then
you would programmatically allow/deny access to editing.