Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!news.astraweb.com!news-small.astraweb.com!news-out.visi.com!petbe.visi.com!ash.uu.net!an02.austin.ibm.com!ausnews.austin.ibm.com!not-for-mail From: Ed Stevens Newsgroups: comp.databases.oracle.server Subject: Can this Sun doc be trusted? Date: Fri, 08 Aug 2003 15:44:15 -0500 Organization: IGS Internet News Server (AUSTIN) Lines: 33 Message-ID: NNTP-Posting-Host: gsine04.us.sine.ibm.com Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: ausnews.austin.ibm.com 1060375156 8004 9.14.6.44 (8 Aug 2003 20:39:16 GMT) X-Complaints-To: abuse@ausnews.austin.ibm.com NNTP-Posting-Date: Fri, 8 Aug 2003 20:39:16 +0000 (UTC) X-Newsreader: Forte Free Agent 1.92/32.572 Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:240126 In starting to do some research for my first clustered installation of Oracle (OPS? RAC?) I was reading through docs at http://docs.sun.com/db/doc/817-1527/6mh8jv3uv?q=oracle+ha&a=view There, in a section on "Ohow to Set Up Oracle Database Permissions" they have this bit . . . To use the Oracle authentication method . . . enter the following . . ." (in SQL*Plus) connect / as sysdba grant connect, resource to default tablespace system quota 1m on system. grant select on v_$sysstat to ; grant create session to ; grant create table to ; then they go on to give a more concrete example: create suer ops$oracle identified by externally default tablespace system quota 1m on system; grant connect, resource to ops$oracle; grant select on v_$sysstat to ops$oracle; grant create session to ops$oracle; grant create table to ops$oracle; What has me concerned about this is making the system tablespace the default for the user oracle. Am I missing something or is Sun simply blindly recommending the lowest common denominator default, kind of like Oracle's poorly configured, shake-it-out-of-the-box starter database?