Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 32218 invoked from network); 8 Nov 2007 14:01:47 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 8 Nov 2007 14:01:45 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5374C7B4816; Thu, 8 Nov 2007 15:01:42 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 11322-03; Thu, 8 Nov 2007 15:01:42 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C37D67B4812; Thu, 8 Nov 2007 15:01:41 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 08 Nov 2007 14:15:13 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DA7147B500B for ; Thu, 8 Nov 2007 14:15:13 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 03833-03 for ; Thu, 8 Nov 2007 14:15:13 -0500 (EST) Received: from plmler4.mail.eds.com (plmler4.mail.eds.com [199.228.142.74]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 609D37B4F0E for ; Thu, 8 Nov 2007 14:15:10 -0500 (EST) Received: from plmlir4.mail.eds.com (plmlir4-2.mail.eds.com [199.228.142.134]) by plmler4.mail.eds.com (8.13.8/8.13.8) with ESMTP id lA8JF3DS015794 for ; Thu, 8 Nov 2007 13:15:03 -0600 Received: from usplsdlp304.amer.corp.eds.com ([148.94.169.151]) by plmlir4.mail.eds.com (8.13.8/8.12.10) with SMTP id lA8JF3hF006285 for ; Thu, 8 Nov 2007 13:15:03 -0600 Received: from plmlir4.mail.eds.com (localhost [127.0.0.1]) by plmlir4.mail.eds.com (8.13.8/8.12.10) with ESMTP id lA8JEr4k005431 for ; Thu, 8 Nov 2007 13:14:53 -0600 Received: from usplm015.amer.corp.eds.com ([148.94.166.8]) by plmlir4.mail.eds.com (8.13.8/8.12.10) with ESMTP id lA8JEqFi005418 for ; Thu, 8 Nov 2007 13:14:52 -0600 Received: from usahm208.amer.corp.eds.com ([130.175.198.40]) by usplm015.amer.corp.eds.com with Microsoft SMTPSVC(6.0.3790.1830); Thu, 8 Nov 2007 13:14:52 -0600 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Subject: RE: Public Grants after Default Install - Complience/Audit Issue Date: Thu, 8 Nov 2007 14:14:51 -0500 Message-ID: In-Reply-To: <003001c8218d$bc61f1e0$6501a8c0@medecision.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Public Grants after Default Install - Complience/Audit Issue From: "Powell, Mark D" To: X-OriginalArrivalTime: 08 Nov 2007 19:14:52.0743 (UTC) FILETIME=[A3D9BD70:01C8223B] X-CFilter-Loop: Reflected X-archive-position: 3075 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: mark.powell@eds.com Precedence: normal Reply-to: mark.powell@eds.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain 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@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Ted Coyle Sent: Wednesday, November 07, 2007 5:30 PM To: oracle-l@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