File: svrmgrl-example.sql

package info (click to toggle)
dotlrn 2.5.0+dfsg-6+wheezy4
  • links: PTS, VCS
  • area: main
  • in suites: wheezy
  • size: 108,272 kB
  • sloc: tcl: 219,601; sql: 202,152; xml: 127,658; java: 7,268; php: 4,780; sh: 2,486; perl: 1,207; makefile: 137
file content (34 lines) | stat: -rw-r--r-- 1,285 bytes parent folder | download | duplicates (6)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
--
-- 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 2001/03/13 22:59:26 ben 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;