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
Why ist the FSB for memory only 100MHz instaed of 133MHz? The chipset i845 can handle 133. Is there any possibility to change it?Hi I dont know where you found the information about 100 MHz and 133 MHz of memory FSB but this value has nothing to do w [More]
Hi - I'm dabbling with iBooks Author.  I'm not intending to submit the book to the iBook Store.  I just want to share it with family members for their iPads. I created a short tale with some text and images - 15 pages, 3 chapters long - and Published [More]
Hi all, I am facing a problem on 10gR2 Application Server, When I try to run a report from portal, Report shows o/p in the excel but when I try to save the O/P by using File -> save as , it shows only 4 types of files like htm, html, txt. I have used [More]
Hi, I am installing NW04 EP6 SR1 installation on Windows 2003 After starting SAPInst the installation hangs at Deploy vid SDM/J2EE at the log shows: PHASE 2006-11-15 17:07:39 Deploying SDAs (using SDM and SAP Java EE Engine). But not going further fr [More]
Hi I have a report with 4 Repeating Frames.It works perfectly fine until it gets same Client names which is one of the Repeating frames. Means the name of the Client is not printed and its relevent details are printed. Following is the query used Sel [More]
how do i install the old software on my mac, i hate YosemitePlease explain me as in what kind of old software do you intend to install on your macbook pro. -    Please tell what OS X do you wish to run on your macbook, as you said you hate Yosemite.. [More]
Hello does anyone know of a way to determine which peer is making the invocation of a method in CORBA? I need to find a way to determine the IP address of the calling peer, but at the server-side and NOT by passing the IP address as an argument with [More]
Iam having common routing for two materials in same plant. I use leadtime scheculing in MRP for both materials. Iam using MTO scenario. Iam getting production dates as per routing dates for one material and basic dates for other materials. i want rou [More]
Hi, I downloaded the new version of Desktop and connected to my playbook. the playbook indicates that there is a comms link ok . when getting started on desktop there is a message : Error occured mounting playbook . Pin 5014AB9F  volumes reconnect yo [More]
Hi Abapers, My Requiremnt is to exclude multiple values which are not in sequence  in selection screen. I want to restrict some values . please provide sample code. thanks & regards, Hari priyaSELECT-OPTIONS : s_matnr FOR mara-matnr. INITILIZATION. s [More]