Re: problems with system priv. Oracle 8

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/05/19
Message-ID: <958747569.23799.0.pluto.d4ee154e@news.demon.nl>#1/1

Most likely you don't have quota on that tablespace. Try alter user <username> quota <bytes>|unlimited on data.

Could you please avoid posting to *all* Oracle newsgroups?

On a sideline (and I don't blame you): as most people don't seem to understand the difference between misc, server and tools (designer/developer) shouldn't we better drop the disctinction? This is only wasting bandwith.

Hth,

Sybrand Bakker, Oracle DBA

afaatz <afaatz_at_kom.tu-darmstadt.de> schreef in berichtnieuws 3925456F.6A38DCA9_at_kom.tu-darmstadt.de...
>
>
> 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