Re: I've now, officially, seen it all...

On Sun, 14 Jan 2007 09:33:02 -0800, Mark D Powell wrote:

> I have a couple of vendor applications that specifiy that select is
> required on specific v$ views and then there are applications like
> MAXIMO that require creation of views owned by user SYS which in turn
> are based on Oracle base tables so I would think creating an
> application view on v$database would result in a more obvious test.

Two comments here:

1. modifying the SYS schema (master catalog) or creating objects directly derived from SYS schema may not be desirable because:
   • may be dangerous to the health of the database (create or drop object);
   • could create a name collision with an existing OR planned SYS object;
   • could inadvertently become a security breach;
   • automatically requires a regression test at each patch;
   • may be a violation of SarbOx or auditing policy;
   • requires cooperation with auditors, DBAs, etc. etc. etc.
2. A number of the requirements MAY be fulfilled using SYS_CONTEXT() function. I've noticed that very few developers (and roughly zero vendors) are familiar with the function or the data returned in the USERENV namespace.

-- 
Hans Forbrich   (mailto: Fuzzy.GreyBeard_at_gmail.com)   
*** Feel free to correct me when I'm wrong!
*** Top posting [replies] guarantees I won't respond.