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 once had sound on YouTube, but now it's gone. All internal audio diagnostics work and I have sound on all other applications. I have downloaded Dell's diagnostics and everything passes.  I am baffled.  HELP!Hi Jennifer, These are the results of you [More]
I need to ask questions about using the program and I try to use this forum but MOST people don't even get any answer. How do I contact the customer service?It's a design mistake. Do the following: 1. There is a 75% black rectangle behind the text li [More]
I completed and ordered a hardcover photo book,  Now I would like to order the same book but with a soft cover or wire bound cover.  IPhoto doesn't seem to have a feature which just lets me change the completed book to another type of cover.see my an [More]
Received iMac today. Transfered files from Mac mini via firewire in about one hour. 2 Gigs ram, high end video card. Machine is very fast. Doom and Halo run great. Microsoft Office runs without a problem. Just as fast or fast than he Mac mini. No pro [More]
Hi all, Since I started using os 10.7.4, i cannot use time capsule to back up. "The backup disk image "/Volumes/*************/*'s iMac.sparsebundle" could not be accessed (error -1)." WIll this issue be fixed if I upgrade to Mountain L [More]
Hi folks, Let's say I have a table with this data: START_DATE  END_DATE 01-OCT-2007 02-OCT-2007 05-OCT-2007 02-OCT-2007 03-OCT-2007 03-OCT-2007 20-OCT-2007 21-OCT-2007I would like a query that would give me each unique date including ones that fall b [More]
hi sap Gurus, i working on PO release with work flow concept, can any one help in this. i have done up to release procedure. i want config. the work flow. can any one give step by step how to do. help full answers will be rewarded. regards kalyanhi k [More]
Hello Experts,                        I am working an object where I need to update the sales order when the delivery changed.                          Actually when the remote system rejected the delivery an IDOC will come to R/3 Sooner the delivery [More]
I have already set up an Apple Id, However I can't get into the iTunes to download because It asks for a credit card. I need to change the payment method to NONE. I do not see a free iTunes app.      thank youPick an application marked as 'Get'; thes [More]
I recently upgraded some software on my desktop (one of the automatic updgrades that pop up when you restart your computer....since doing that, there are certain pictures that won't open when I go to certain websites. Instead there is just a box with [More]