title: I can't create a view in oracle database using sqlplus (insufficient privileges)
body: <p>I'm running this SQL:</p>
  
  <pre><code>CREATE VIEW
  showMembersInfo(MemberID,Fname,Lname,Address,DOB,Telephone,NIC,Email,WorkplaceID,WorkName,WorkAddress,WorkTelephone,StartingDate,ExpiryDate,Amount,WitnessID,WitName,WitAddress,WitNIC,WitEmail,WitTelephone)
  AS SELECT 
  mem.MemberID,mem.FirstName,mem.LastName,mem.Address,mem.DOB,mem.Telephone,mem.NIC,mem.Email,
  wrk.WorkPlaceID,wrk.Name,wrk.Address,wrk.Telephone,
  anl.StartingDate,anl.ExpiryDate,anl.Amount,
  wit.WitnessID,wit.Name,wit.Address,wit.NIC,wit.Email,wit.Telephone 
  FROM Member mem, WorkPlace wrk, AnnualFees anl, Witness wit 
  WHERE mem.MemberID = anl.MemberID AND mem.WorkPlaceID = work.WorkPlaceID AND mem.WitnessID = wit.WitnessID
  </code></pre>
  
  <p>When I try to create the view I get this error:</p>
  
  <blockquote>
    <p>ERROR at line 1:<br>
    ORA-01031: insufficient privileges</p>
  </blockquote>
  
  <p>Why is that? I'm logged in to sqlplus using sysman</p>