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
Hi All, I know that standard SAP will get the Customer number into Insp. lot only for insp. types 10/11/12.  I am wondering if someone know a way to get the customer no. into insp. lot for insp. type 04 where the material is make-to-order scenario an [More]
How do I transfer all my data, including and especially iTunes, from my old Power PC G5, running MAC OSX 10.5.8, to my husband's new 27" MAC?  His iTune collection is minimal, mine over 2,000 songs.  I would like his computer to become my only workin [More]
The Volume Shadow Copy service initially was running under the context of System, so we thought that 'System' doesn't have permissions to access network shares.  When the Volume Shadow Copy service was running under the context of System, this was th [More]
my Iphone 4s will not sync with my mac(10.4.11) itunes (9.2.1) but will open iphoto and download photos.Printed right on the box: Syncing with iTunes on a Mac or PC requires: Mac: OS X v10.5.8 or later PC: Windows 7; Windows Vista; or Windows XP Home [More]
Hi experts,   How many versions are there in SAP XI..   currently i am working on SAP XI 3.0.   what is the difference between new 3.0 and new versions... Thanks, Swetha reddyNow the latest version is PI7.1 which contains below features, JDBC and RFC [More]
there is no software update in y iphone 3gs, version 4.0.1. how can i upgrade to ios 4.3?http://support.apple.com/kb/HT4972 This procedure will upgrade the phone to the most recent version (6.1)Read other 4 answers [More]
HI,              My Mac is not responding to anything not even when power conected it suppose to be lit-up when conected to power now its not showing any thing and ON/Off switch is also not responding.. please can any one help?Have you pressed the ba [More]
If I download a Office for Mac Trial, can I upgrade to the full version by simply purchasing online and entering a serial number to activate right there and then? (Without waiting for the box to arrive?)Yes.Read other 2 answers [More]
Hello, I am looking for comments/advice on implementing a JMS component as a standalone application versus a J2EE (message driven bean). Mainly in terms of experience or pros and cons of each technology. We are implementing the component from scratch [More]
i forgot my passcode to my phone need to reset itRestore the iPhone using the last computer you synced the phone to. This will remove the passcode and restore the backup.Read other 2 answers [More]