RE: Public Grants after Default Install - Complience/Audit Issue

I think dba_policies is a better view for this:

UT1 > desc dba_policies

 Name                                      Null?    Type
 ----------------------------------------- --------


----------------------------

 OBJECT_OWNER                                       VARCHAR2(30)
 OBJECT_NAME                                        VARCHAR2(30)
 POLICY_GROUP                                       VARCHAR2(30)
 POLICY_NAME                                        VARCHAR2(30)
 PF_OWNER                                           VARCHAR2(30)
 PACKAGE                                            VARCHAR2(30)
 FUNCTION                                           VARCHAR2(30)
 SEL                                                VARCHAR2(3)
 INS                                                VARCHAR2(3)
 UPD                                                VARCHAR2(3)
 DEL                                                VARCHAR2(3)
 CHK_OPTION                                         VARCHAR2(3)
 ENABLE                                             VARCHAR2(3)
 STATIC_POLICY                                      VARCHAR2(3) 

• Mark D Powell -- Phone (313) 592-5148

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ted Coyle Sent: Wednesday, November 07, 2007 5:30 PM To: oracle-l_at_freelists.org
Subject: *****SPAM***** Public Grants after Default Install - Complience/Audit Issue

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$?

• Ted

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Thu Nov 08 2007 - 13:14:51 CST