ORA-01031: insufficient privileges
726227Oct 6 2009 — edited Oct 6 2009I am new to SQL.I installed Oracle Database 10g in my system and created a database named as scott using hr schema. Now when i try to create a view i got following error message ORA-01031: insufficient privileges .I understood that scott doesnot have sufficient privilage to create the view but how to introduce that privilege using database administrator that i don’t know. Any help will be greatly appreciated.