I granted CREATE SESSION, CREATE TABLE, CREATE SEQUENCE, CREATE VIEW privileges TO USER 'BAL' FROM DBA 'SCOTT'. Then I loged on as USER 'BAL', User BAL tried to create a table I had following error.
SQL> CREATE TABLE MM
2 (col NUMBER);
CREATE TABLE MM
ERROR at line 1:
ORA-01950: no privileges on tablespace 'SYSTEM'
What does it mean? I am following "OCP Introduction to Oracle9i: SQL Exam guide". I do not see any tablespace privileges mentioned in the book. Just it says there is more than 80 privileges. How can I get rid of this? Where can I find details on this?
Any response, direction highly appriciated. Thanks, -Bal