Re: Strictly Enforcing Query Plan Stability

I was under the impression that you can't place triggers on objects owned by SYS. I may be wrong.

But if not, it was a cunning plan you had there. Unfortunately, not as cunning as a professor of cunning from Oxford University.

Regards
HJR

--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------

"Greg Stark" <greg-spare-1_at_mit.edu> wrote in message
news:87n1fn1vur.fsf_at_HSE-MTL-ppp62507.qc.sympatico.ca...


>

> So now I have an idea. What happens if you turn on CREATE_STORE_OUTLINES

 and


> USE_STORED_OUTLINES but you put a triggger on OUTLN.OL$ that checks if the

> current user is the user you want to restrict and throws an error?

>

> --

> greg