Re: v$parameter

Roger Snowden wrote in message <367F01CC.90C5FB4_at_NOT.com>...
>Microsoftitis? Yuchh! I'm not sure what that means, but it certainly
>doesn't sound pretty.

Is anything from Cruella the Bill pretty apart from the screen-savers?

("screen-saver face": a Windows 95 "expert") <G>

>My employment with Oracle notwithstanding, I
>personally find the product line quite consistent.

Me too. After 14 years using the product, I still find it better than most. But things change...

>The role/stored
>procedure thing works that way for some very good reasons.

Yeah, I can see why. I just don't like it. It's not in line with the rest of the behaviour of roles for normal SQL and PL/SQL. Alternative solutions? Yeah, I know: create a schema with the packages, authorize tables to the schema and users to the packages . But that is not always practical...

>The access
>you have that seems inconsistent ought to be investigated. You may find
>that there are explicit grants you are not aware of.
>

I found them. Thomas gave me a lead. Didn't look good when I looked. Gotta fix it up now... The DBA that has spent most of the last 14 months forcing me to only access his production schema via roles wasn't happy though! Oh well, can't win them all...

--
Cheers
Nuno Souto
nsouto_at_acay.com.au Received on Wed Dec 23 1998 - 08:11:03 CST