Oracle 11GR1 upgrade to 11GR2 and schemas with Apex_030200.Apex_application and more

[OlamobisiFawehinmi]

Hi

Previous setup was ArcSDE 9.3.1 SP1 on Oracle 11gR1. We recently upgraded to 11gR2 and now all users logged into the database can see schema tables like APEX_030200.APEX_ACTIVITY_LOG and more tbales in that schema along with some other tables that read only viewers with only create session pages should not be able to see. Has anyone come across this or know how to remove access to these tables/schemas?

Thanks

Joseph

[OlamobisiFawehinmi]

Doing some more digging with the apex....., seems like this behaviour has been sorted with the ArcSDE 9.3.1 SP2 service pack. Anyone able to confirm that this has worked for them?

Thanks
Joseph

[ForrestJones]

Hi Joseph,

Yes I have confirmed it is fixed in 9.3.1 SP2 with this nimbus bug:

"NIM052156 - Ora11gR2 APEX* & ORDDATA* tables need to be filtered."

It is also listed in the issues addressed in 9.3.1 SP2:
http://downloads2.esri.com/support/downloads/other_/ArcSDE-931sp2-issues.htm

[H__KorayGUNDUZ]

Hi Joseph,

#Apex Uninstall

cd oracledirectory/apex
sqlplus sys/password as sysdba
@apxremov.sql

e.g
cd /u01/app/oracle/product/11.2.0/db_1/apex
sqlplus sys/oracle as sysdba
@apxremov.sql

or

ArcSDE update
"NIM052156 - Ora11gR2 APEX* & ORDDATA* tables need to be filtered."

It is also listed in the issues addressed in 9.3.1 SP2:
http://resources.arcgis.com/content/patches-and-service-packs?fa=viewPatch&PID=66&MetaID=1623

and

http://resources.arcgis.com/content/patches-and-service-packs?fa=viewPatch&PID=66&MetaID=1718


Regards