User privileges
Date: Tue, 3 Apr 2001 07:54:32 -0400
Message-ID: <D577E02F49A4A8498167BA5E41424D47CB26B1_at_expf1.sauder.com>
There is a quota associated with each user for each tablespace in your database. I've seen this error when the quota is set to "none" for the table that I'm attempting to add an object to. This can either be changed using OEM or with the ALTER USER "userid" QUOTA xxx ON tablespace name; SQL statement where xxx is either UNLIMITED or the size in Kb or Mb.
-----Original Message-----
From: Rusty Fadgen [mailto:rfadgen_at_cfl.rr.com]
Posted At: Sunday, April 01, 2001 10:24 PM
Posted To: oracle
Conversation: ora-01950 no privilages on table space 'Users'
Subject: ora-01950 no privilages on table space 'Users'
Sorry I'm a Beginner! I get this error while using this query:
Create table emp (
empno number(4) NOT NULL,
ename varchar2(10),
job varchar2(9),
mgr number(4),
hiredate date,
sal number(7,2),
comm number(7,2),
deptno number(2) Not NULL,
CONSTRAINT Emp PK Primary Key (empno))
What privelage do Ineed to add to which object to be able to allow users
to
run this query and create a table??
Thanks in advance
--
Received on Tue Apr 03 2001 - 13:54:32 CEST