-- -- bin/svrmgrl-example.sql -- -- An example file to create a tablespace with the -- appropriate permissions. -- -- @author Richard Li (richardl@arsdigita.com) -- @creation-date 1 October 2000 -- @cvs-id $Id: svrmgrl-example.sql,v 1.1.1.1 2002/07/09 17:34:56 rmello Exp $ connect internal; -- substitute a tablespace creation statement appropriate for your -- installation. this exact statement should almost never be used -- exactly as is. create tablespace yourservicename datafile '/ora8/m02/oradata/ora8/yourservicename01.dbf' size 50m autoextend on default storage (pctincrease 1); create user yourservicename identified by yourservicename default tablespace yourservicename temporary tablespace temp quota unlimited on yourservicename; grant connect, resource, ctxapp, javasyspriv, query rewrite to yourservicename; revoke unlimited tablespace from yourservicename; alter user yourservicename quota unlimited on yourservicename; -- these are necessary for utPLSQL. you shouldn't grant these on a -- production system unless absolutely necessary. grant create public synonym to yourservicename; grant drop public synonym to yourservicename; grant execute on dbms_pipe to yourservicename; grant drop any table to yourservicename; grant create any table to yourservicename;