ORACLE HELP!!! :(

[puffpio]

I'm not a database guy, yet I've been dropped with this task.

I'm trying to create a new account that has it's own tables and stuff and I'm having a real hard time. The GUI/web interface to teh db is down..so I have to do everything through sqlplus

so far I've logged in as the admin and done

create user username identified by password;
grant connect to username;
grant create tbale to username;


so then i login as the new user..i'm able to connect....but I can't create tables saying no priveldges on tablepace 'users'


what do i need to do in order to get this new account up and running..I need to able to create delete insert drop select from tables etc

 

[alisajid]

Yeah, you need to assign a tablespace to that user. A tablespace is a logical storage unit that maps to one or more data files. The user will have his/her tables stored in the tablespace.

If you already have a user tablespace setup:

alter user <USER NAME> quota unlimited on <YOUR TABLE SPACE NAME>;

If you need to create a tablespace (replace with your own data dir):

create tablespace <YOUR TABLESPACE NAME> datafile 'C:\oracle\product\10.2.0\oradata\devdb\app_tbs01.dbf' size 128m autoextend on next 32m maxsize 4096m;

grant create session, create table, create view, create procedure, create synonym, create type, create sequence, create cluster to <USER NAME>;