problems with system priv. Oracle 8
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