how to give prevalages in oracle 9i

[mktilu]

hi
i am trying to create a table but i am getting this message how to solve this proble in oracle 9i

SQL> create table t1(sno number(10));
create table t1(sno number(10))
*
ERROR at line 1:
ORA-01031: insufficient privileges

[chandu031]

hi
i am trying to create a table but i am getting this message how to solve this proble in oracle 9i

SQL> create table t1(sno number(10));
create table t1(sno number(10))
*
ERROR at line 1:
ORA-01031: insufficient privileges

Hi,

Try this:

GRANT CREATE ANY TABLE TO user

If you still get errror after this , then you will have grant the tablespace permission to the user :

GRANT RESOURCE TO user

[debasisdas]

It seems from the user u r trying to execute the create table command does not have resource previlidge on the schema.

to solve this problem ask your DBA
or
login through any DBA account and

grant the preveiledges like

GRANT CONNECT,RESOURC E TO USERNAME;

It will work