Re: sysdba role in script

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