column_priv ? restricting user privileges

[jarow]

I have a table with the following columns:

Phylum
Class
Order
Family
Species

Example 1: Let´s say I want to grant limited privileges to a user so he can change anything he wants in the ORDER Coleoptera, i.e., he can change any information in the FAMILY and SPECIES columns that correspond to the ORDER Coleoptera. He cannot change anything in Phylum or Class.

Example 2: I want to grant limited privileges to a user so that he can change anything he wants in the FAMILY mylitidae, i.e. he can change any information in the SPECIES column that corresponds to the FAMILY mylitidae. He, in turn, cannot change anything in Phylum, Class or Order.

That´s the general idea....Does anyone have any idea how I can do this?

Many thanks

Jim

[raf]

Yes, i've got an idea: you're application should have these restrictions build in.
At db-level, you van only restrict on variable (columns) level. So they wount be able to change any records value in that column.

So you need some kind a db-frontend that identifies the user and only allows the actions they are permitted to perform