Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Building security into data structure.

Building security into data structure.

From: Pavs <pavle_sturma_at_hotmail.com>
Date: 11 Nov 2001 17:49:30 -0800
Message-ID: <692c44aa.0111111749.6f469695@posting.google.com>


I am trying to model some security of data in a data structure I am designing.

I have an object which is described by a profile. Each object can only have one profile.

The object also has access restrictions. The restrictions or security is based on the object profile. So if the object is profile1 then it gets security1 and if profile2 then gets security2.

I was planning to have of course an OBJECT_TABLE, PROFILE_TABLE, & SECURITY_TABLE. Now should I also come up with a 4th table that would map profile against security and then link it back to the object table?

Any thoughts would be appreciative

BTW I am a novice

Thanks Received on Sun Nov 11 2001 - 19:49:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US