Data Modeling: User Specific Column Retrieval

Hi

I have a question for modeling gurus.

I have a table which stores documents, one per record. The document has 16 sections, each represented by a column in the table.

I have several users accessing this data, each user represented by a userID in Users Table.

Some users can access only some columns in the document table. The access rules are table wide generally, but would like to make them row specific, if possible.

I need to design a schema, where I can represent the access rules for each user, preferably at row level, table level would be fine for now.

TIA,
S.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Mar 30 2000 - 00:00:00 CEST