Sitemap

Amicuk Programming Answers

Virtual private database and cascade delete

-0001-11-30   Views:0

Advertisement

We can't secure rows deleted by cascade delete by vpd. User "A" have right to delete row "1" but don't have right to delete row "2". If user "A" delete row "1", database will delete also row "2"

We can't secure rows deleted by cascade delete by vpd.
User "A" have right to delete row "1" but don't have right to delete row "2".
If user "A" delete row "1", database will delete also row "2" by cascade delete.
Why it is possible to delete row "2"?

The replay answer
Advertisement
Either of the two options (a policy that queries the base table or propagating the security columns to the child tables) should work.
My preference from a data model standpoint would be to have a policy that queries the base table so that the security information can be maintained in exactly one place. But if your application is frequently querying the child tables without reference to the parent table, joining to the parent table, particularly if data volumes are such that an IN would be less than ideal, there may be performance issues to this approach.
Copying the columns creates a potential data integrity problem-- if you change the security on a base table row, you may forget to change the security on all the child records. But that issue may not be significant if the security is essentially static once the rows are created. And it's definitely easier to tune.
You may also want to create views that join the parent and child tables and grant users access to these views rather than to the child tables directly, which would allow you to have a single policy on the base table and get most of the benefits of the first option with less performance problems if data volumes make an IN less than ideal.
Justin

Go to See the other 2 answers

Virtual private database and cascade delete

Category:DefaultRelease time:-0001-11-30Views:130

We can't secure rows deleted by cascade delete by vpd. User "A" have right to delete row "1" but don't have right to delete row "2". If user "A" delete row "1", database will delete also row "2"[More]

Implement row-level security using Oracleu2019s Virtual Private Databases (VPD)

Category:DefaultRelease time:2015-10-11Views:130

Environment: Business Objects XI R2; Oracle 10g Functional Requirement: Implement row-level security using Oracleu2019s Virtual Private Databases (VPD) technology. The restriction is that the Business Objects Universe connection should use a generic/[More]

Use of Virtual Private Database

Category:DefaultRelease time:-0001-11-30Views:130

Hello our company is in e-business and wants to expore new features of Oracle 9i for next project. one of the option for security is Virtual Private Database. i was just wondering how much VPD is useful in an application where there is connection poo[More]

About Virtual Private Database

Category:DefaultRelease time:-0001-11-30Views:130

Hi All, Oracle provided two ways to implement D.B securities. 1. RBAM(Role base access model) 2. RLS(Row level security) So the quey is which one is best method for implementation of securities in database suppose we don't have any requirement for ro[More]

Virtual Private Database

Category:DefaultRelease time:-0001-11-30Views:130

Hi All, We are using Oracle 11g R2 and we would like to implement Virtual Private Database. We have an application connected to LDAP with serveral users. The users are also created in Weblogic. The Application is using only with Oracle schema with ma[More]

Using VPD (Virtual Private Database) with Discoverer for Dummies

Category:DefaultRelease time:-0001-11-30Views:130

Firstly could you please excuse me for the title of the thread, but it's all I could come up with. For those of you who are looking at me with a strange look of disgust, please view thread that started it all: BIS vs DBI vs Noetix . Otherwise I'm hop[More]

Row level access, virtual private database, label security

Category:DefaultRelease time:-0001-11-30Views:130

Hello All, I'm experiencing an issue.... I've a datawarehouse where some tables, for examples orders are shared for two different countries. Difference is made simply with a field country may contain country_id. So using OBI and publisher I need to p[More]

About virtual private databases

Category:DefaultRelease time:-0001-11-30Views:130

I've read in the documentation that: Oracle Virtual Private Database enforces security, to a fine level of granularity, directly on database tables, views, or synonyms. Because you attach security policies directly to these database objects, and the[More]

Oracle Virtual Private Database (VPD), Column Level Security

Category:DefaultRelease time:-0001-11-30Views:130

Hello, About Oracle Virtual Private Database (VPD), is it possible to set a Column Level Security without setting a Row Level Security (without using any predicate)? Thanks, Herve.Thanks, Zoran. A colleague shared with me a link containing a function[More]

ADF BC + Virtual Private Database

Category:DefaultRelease time:-0001-11-30Views:130

First and foremost, as it's my first post here i'd like to say hello to you all. I hope i'll get answers to my questions and help others as well with my (little) experience. But for now i'm in need of help. We're currently developing our first web ap[More]

Where Is The Virtual Private Database Option

Category:DefaultRelease time:-0001-11-30Views:130

In apex 3.2, I could find the Virtual Private Database option in Shared Components/Security I am now using Apex 4.2 and I cannot find this option under Shared Components/Security or anywhere else. Where has it gone ? GusHi, It is in same place, but r[More]

Hot
I use Premiere CS6. Most of my work requires simply editing with one audio track used for the on-camera talent's microphone, adding another track for music, and then outputting BOTH of those tracks to the right channel as a mixed mono output AND the [More]
I installed the Mac OS X Lion two days. But I can't drag and drop with a Double tap using Single Finger, which I used to do in Snow Leopard. If I choose Three Finger Move, then Swap Between Pages goes back to "Scroll left or right with Two Fingers&qu [More]
Hello, world... I have a problem... I need to call a server function by pushing a button. I put the condition on the label... This is my script: writeBtn1.addEventListener (MouseEvent.CLICK,writeFile1); private function writeFile1 (e:MouseEvent=null) [More]
I have tried everything downloading iso5. What can I do? On my general selection, there is no software update. Can't figure it oit. HelpConnect the device you wish to upgeade to iOS 5 to your computer and upgrade using iTunes. AllanRead other 2 answe [More]
WebLogic 12.1.2 fails when deploying an enterprise application(ear) that contains a ejb in which injected 1) an extension 2)bean with injection of this extension. The following exception is thrown: Caused By: org.jboss.weld.exceptions.DeploymentExcep [More]
Dears, We have Guest Portal on ISE server, when our guests connect to Guest SSID they automatically redirected to WEB portal it works only with http websites if user writes in his browser for example facebook.com or some websites with https redirecti [More]
If I open an existing css file with the code content=""; make some other changes and save the content it disappears. My guess is that this is some kind of language/character/utf related setting? I only have this problem in Dreamweaver CC, not i [More]
Back up to time machine failed.  Error, "Files can't be copied onto the backup disk because it appears to be read-only". Back up has been working.  drive is not read only.  How do I fix this?Hello, http://pondini.org/TM/C6.htmlRead other 2 answe [More]
hi i need to add approver in FIAP report. the filed is available not any table like, its getting from abap work flow? please let me know  normally will be possible to extract data from work flow?Hi, There is no direct method i am aware of, but you ca [More]
Hi. I think the whole day on this thing: In this example http://www.stanko-b.com/heelbopps/ (project https://www.dropbox.com/s/dr41wme9uqnm0a9/heelbopps4.zip) when you press the "down" button, the screen scrolls down to a particular object. Сode [More]