I can't create a view in oracle database using sqlplus (insufficient privileges)
        Posted  
        
            by Nubkadiya
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by Nubkadiya
        
        
        
        Published on 2010-06-16T14:15:00Z
        Indexed on 
            2010/06/16
            14:22 UTC
        
        
        Read the original article
        Hit count: 368
        
I'm running this SQL:
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
When I try to create the view I get this error:
ERROR at line 1:
ORA-01031: insufficient privileges
Why is that? I'm logged in to sqlplus using sysman
© Stack Overflow or respective owner