-- Do not drop roles -- 10/19/2007 epaglina Repository Upgrade Feature
-- drop role %owb_user_role;
-- drop role %view_public_role;
drop table OWB_ROLE_INFO;
drop package body secHelper;
drop package secHelper;
drop package body WBSecurityServiceImpl;
drop package WBSecurityServiceImpl;
drop type SEC_STRINGLIST;
drop type SEC_OBJECTINFOLIST;
drop type SEC_INTEGERLIST;
drop type SEC_UOIDLIST;
drop index IDX_FCO_READ_LOOKUP_PRIVID;
drop index IDX_FCO_READ_LOOKUP_FCOID;
drop index IDX_SCOFCOID;
drop index IDX_SCOCfgFCOID;
drop index IDX_SCOMapFCOID;
drop index IDX_SCOPrpFCOID;
drop view FCO_READ_LOOKUP_V;
drop table FCO_READ_LOOKUP;
drop package body SECURITY_PV_UTILITIES;
drop package SECURITY_PV_UTILITIES;
drop package body ManagePrivilegeFromDB;
drop package ManagePrivilegeFromDB;
drop table SYS_PRIV_ID_TO_NAME_TAB;
drop table   OBSOLETE_OBJ_PRIVS;
drop table     OBSOLETE_SYS_PRIVS;
drop table  OBJ_PRIV_ID_TO_NAME_TAB;                                   
drop type privList;
drop type  priv_t;
drop procedure start_access_publicview;
drop function getSecText;
drop function hasAccessBrowserPrivilege;