problems with system priv. Oracle 8

From: afaatz <afaatz_at_kom.tu-darmstadt.de>
Date: 2000/05/19
Message-ID: <3925456F.6A38DCA9_at_kom.tu-darmstadt.de>#1/1


 Hello out there,
[Quoted] as a beginner to Oracle 8.1.5 I wonder why the following doesn't work.  Successfully I created
 a tablespace called 'data'. Without any error messages I performed the  following sql-script:


 CREATE ROLE SFK_R; [Quoted]  GRANT connect, create session to SFK_R;

 CREATE USER sfk_u
  identified by smallt
  DEFAULT TABLESPACE data
  TEMPORARY TABLESPACE data_tmp;

 GRANT sfk_r to sfk_u;


[Quoted]  Successfully I logged in as sfk_u, but trying to create a table I failed
 with the error message:


[Quoted]  ORA-01950: no privileges on tablespace "DATA"


[Quoted]  Well, I also tried the script granting create table to sfk_r, but again  I faild receiving the same
 error message.
 Can anybody please help me ?

 Greetings,
 Andreas Faatz
 KOM
 University Of Darmstadt
 Germany Received on Fri May 19 2000 - 00:00:00 CEST

Original text of this message