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?
CONNECT
role has only theCREATE SESSION
privilege (In previous versions it also contained theCREATE VIEW
privilege.). For this reason, your code lineGRANT CREATE SESSION TO THE_USER;
is not needed.