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?
Best Answer
You can create tables because the RESOURCE role has the CREATE TABLE privilege granted. To create a view, you need to have granted the CREATE VIEW privilege additionally, because, by default that privilege is not granted, not even to RESOURCE.
So you need to do the below: