Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Changes made under one user not visible with other....
I have done that....but it still shows the old version of the procedure(page).
I dropped the synonym while logged in as both ctxsys and as well as my other user. The page - as expected - showed up undeclared when this happened. But when I re-created the synonym, the old version of the procedure showed up, when logged in as someone other than ctxsys.
It's almost as though the page is being cached somehow.....but it is not(at least not in the browser, I've cleared out all of temp internet files.....)
Any ideas?
-- "Matt B." <mcb_at_fightspam.sd.znet.com> wrote in message news:sn7ffn9fo5316_at_corp.supernews.com...Received on Tue Jul 18 2000 - 00:00:00 CDT
> "Joseph Ranseth" <jransethNO_SPAM_at_worldcupfishing.com> wrote in message
> news:KCHc5.5788$Rz1.43831_at_news1.mts.net...
> > I've made changes to a stored procedure (web page) owned by user
'ctxsys'.
> >
> > When I log in to the website under a different user, the changes are not
> > visible.....what do I need to do in order to make things visible for all
> > users?
> >
> > Thanks,
> > JR
>
> Make synonyms for the other users that point to it:
>
> create synonym myproc for ctxsys.myproc
>
> (But you'd need to do that for every user.)
>
> Or just make one public synonym once while logged in as ctxsys:
>
> create public synonym myproc for ctxsys.myproc
>
> -Matt
>
>
![]() |
![]() |