Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: sysdba role in script

Re: sysdba role in script

From: <bofh1234_at_hotmail.com>
Date: 7 Feb 2007 13:33:18 -0800
Message-ID: <1170883998.146672.273200@a34g2000cwb.googlegroups.com>


To recap:

This is the script:
connect sys as sysdba
create tablespace test datafile '/u03/oradata/prod/test01.dbf size 200M;
create user harry identified by password default tablespace test temporary tablespace temp quota 24M on test; grant connect, resource, sysdba to harry; conn harry/potter
create tablespace data2 datafile '/u03/oradata/prod/data201.dbf' SIZE 300M;

When I run the above script I get
Tablespace created.
User created.
Grant succeeded.
Connected.
CREATE TABLESPACE data2 DATAFILE '/u03/oradata/prod/data201.dbf' SIZE 3M
*
ERROR at line 1:
ORA-01031: insufficient privileges

If I create the user, grant the rights, exit sqlplus, login as harry the create tablesspace data2 .... works fine.

Thanks, Received on Wed Feb 07 2007 - 15:33:18 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US