Public Grants after Default Install - Complience/Audit Issue

From: Ted Coyle <oracle-l_at_webthere.com>
Date: Wed, 7 Nov 2007 17:30:00 -0500
Message-ID: <003001c8218d$bc61f1e0$6501a8c0@medecision.com>

10.2.0.3 DBCA custom created database using only the standard Oracle options and nothing else...

Simple user created.
Create user test identified by test default tablespace users; Grant create session to test;

Connecting to test and select from all_tables shows the following sys and system tables exposed to public.

OWNER                         |TABLE_NAME


------------------------------|------------------------------

SYS                           |SYSTEM_PRIVILEGE_MAP
SYS                           |TABLE_PRIVILEGE_MAP
SYS                           |STMT_AUDIT_OPTION_MAP
SYS                           |AUDIT_ACTIONS
SYSTEM                        |DEF$_TEMP$LOB
SYS                           |PSTUBTBL       --- forms 3.0?
SYS                           |WRI$_ADV_ASA_RECO_DATA
SYS                           |ODCI_SECOBJ$
SYS                           |ODCI_WARNINGS$
SYSTEM                        |OL$
SYSTEM                        |OL$HINTS
SYSTEM                        |OL$NODES
SYS                           |KU$NOEXP_TAB
SYS                           |IMPDP_STATS

Can I remove the public grants from the list above? Also, why doesn't every Oracle Object have a searchable definition online? Example: what is ODCI_SECOBJ$?

--

http://www.freelists.org/webpage/oracle-l Received on Wed Nov 07 2007 - 16:30:00 CST