problems with system priv. Oracle 8

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

Hello out there,
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; 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;

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

ORA-01950: no privileges on tablespace "DATA"

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 CDT