- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
Oracle Label Security - distinguish read/write access
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?