2 More explanation
source | link

There is a user as HRS. I am creating a view in HRS as

CREATE VIEW HRS.RNS.....

I am getting

ORA-01031: insufficient privileges

Why? Why can't an ownerEdit

As i remember, i only execute following commands for the user and then my user can create an object in its own schematables

GRANT UNLIMITED TABLESPACE TO THE_USER;
GRANT CONNECT, RESOURCE TO THE_USER;
GRANT CREATE SESSION TO THE_USER;

How does my user automatically get rights to create table but not view?

There is a user as HRS. I am creating a view in HRS as

CREATE VIEW HRS.RNS.....

I am getting

ORA-01031: insufficient privileges

Why? Why can't an owner create an object in its own schema?

There is a user as HRS. I am creating a view in HRS as

CREATE VIEW HRS.RNS.....

I am getting

ORA-01031: insufficient privileges

Edit

As i remember, i only execute following commands for the user and then my user can create tables

GRANT UNLIMITED TABLESPACE TO THE_USER;
GRANT CONNECT, RESOURCE TO THE_USER;
GRANT CREATE SESSION TO THE_USER;

How does my user automatically get rights to create table but not view?

1
source | link

Why can't an owner create a view?

There is a user as HRS. I am creating a view in HRS as

CREATE VIEW HRS.RNS.....

I am getting

ORA-01031: insufficient privileges

Why? Why can't an owner create an object in its own schema?