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
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?