title: insufficient privileges in oracle 10g
body: <p>i have created a table which is as belows . </p>
  
  <p><a href="https://i.stack.imgur.com/fTYnR.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/fTYnR.png" alt="enter image description here"></a></p>
  
  <p>The structure of the table is as follows : </p>
  
  <pre><code>Create Table advanced
   (Id  varchar(15),
   Name varchar(20),
   Dept  varchar(15),
   Cgpa  float,
   Birth_date date,
   Mob_no  int,
   Dist varchar(20),
   Salary  number(8));
  </code></pre>
  
  <p>When I want to create view as follows the sql plus gives me error 'insufficient privileges ' . </p>
  
  <pre><code>Create View advanced_data as
  (
  select name,dept,dist,salary from advanced
  );
  </code></pre>
  
  <p>How can I solve this issue ? </p>