Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Public Grants after Default Install - Complience/Audit Issue

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US