Forum Stats

  • 3,825,003 Users
  • 2,260,454 Discussions


Oracle Label Security - distinguish read/write access

bb_as Member Posts: 13 Red Ribbon

I'm trying to understand the basics of Oracle Label Security. I succeeded in restricting access to a table, so that some users see all rows and some other users see only a subset of rows.

But there is one thing that I don't understand: how can I distinguish between "read only access" and "read/write access"?

Let's say, I have a table MYTABLE and users ADMIN and WORKER.

Both ADMIN and WORKER should be able to read and write all rows in MYTABLE, with one exception: there are some rows in MYTABLE that should only be written by ADMIN.

Any clue how this can be accomplished? If possible, I only want to use levels, or do I need compartments and/or groups for this?