Home » SQL & PL/SQL » SQL & PL/SQL » does not create new table when i create new user
does not create new table when i create new user [message #3275] Tue, 17 September 2002 02:43 Go to next message
harish agarwal
Messages: 38
Registered: September 2002
Member
I created new user using
grant connect to username identified by
password

Now i Entered as new user and when i try to create table it's giving something like....

SQL> create table test(ename varchar2(20));
create table test(ename varchar2(20))
*
ERROR at line 1:
ORA-01950: no privileges on tablespace 'SYSTEM'

please help me
harish
Re: does not create new table when i create new user [message #3276 is a reply to message #3275] Tue, 17 September 2002 05:43 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
you need to grant roles/privs..

grant resource,connect to new_user;

will do that.
Previous Topic: Re: I WANT TO RUN ALL THE ROWS FROM ALL THE TABLE IN ONE COMMAND OR ONE SCRIPT
Next Topic: help with decode statement
Goto Forum:
  


Current Time: Sun May 05 23:37:56 CDT 2024