The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 |
Newsgroups: comp.databases.oracle.server
From: Noons <wizofo...@yahoo.com.au>
Date: Fri, 7 Dec 2007 23:27:32 -0800 (PST)
Local: Sat, Dec 8 2007 2:27 am
Subject: Re: Deadly OPTIMIZER_SECURE_VIEW_MERGING=TRUE
On Dec 6, 5:08 am, Ben <benal...@yahoo.com> wrote:
> problem. I'd would have to say it is probably because the ERP system Bingo. If they are fully qualified table references > uses fully qualified sql statments. (owner.table_name) then the problem doesn't show up. > Do you know if this can happen if you are logged in as one of the When I got hit, our application had a generic login > schema owners? Is this limited to a certain platform? and used a "alter session set current_schema" on the login trigger to give it access to tables of a given schema. Our sql had no owner.table_name as we wanted to be able to execute it against a different set of tables by simply changing the login trigger. Turned out to be a surprise party... You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
| |||||||||||||