Re: alert #68 patches
- From: Walter Montalvo <montalvo2@xxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 30 Sep 2004 13:10:04 -0700
I think Catherine's point is that V_$PARAMETER was removed from the SELECT
privileges for a local role.
So, for instances that have custom roles with grants on V_$PARAMETER, the
patch might remove them, breaking the applications/scripts that depend on
the role having the proper grants.
This will not show itself as something wrong with the view
V_$PARAMETER. It would show itself as objects becoming INVALID after the
patch, due to the removal of the grant. However, for scripts, you cannot
tell until you run them.
This should be the case on most installations, I would imagine.
Walter
At 11:47 AM 9/30/2004, Jerome Roa wrote:
>I upgraded from 9204 to 9205 and applied the #68 patch and it seems to be OK.
>Sun Solaris. V_$PARAMETER is ok. so is V$PARAMETER
>
>
>At 02:39 PM 9/30/2004 -0400, Catherine LeBlanc wrote:
> >After applying patch 3811887 for alert #68, all of a sudden we had scripts
> >failing. It appears that select on V_$PARAMETER was removed from a local
> >role by the patch. This did not show up in our initial post-patch testing
> >since my group all has SELECT_CATALOG_ROLE which still includes select on
> >V_$PARAMETER.
> >Has anyone else experienced anything like this? We are on 9.2.0.4 on Tru64
> >UNIX.
> >
> >Thanks,
> >Catherine LeBlanc
> >
> >--
> >//www.freelists.org/webpage/oracle-l
>
>--
>//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
