ORACLEsoctt cannot create a view

ORACLE scott user create view error: CREATEORREPLACENOFORCEVIEWclasses_viewASSELECT * FROMclasses; -- create view statement row 1st error: ORA-01031: insufficient permissions solution: 1. View Current scott user permission select * fromsession_privs; -- check whether there are CRES in the result.

ORACLE scott user error creating VIEW: create or replace noforce view classes_view as select * FROM classes; -- create view statement row 1st error: ORA-01031: insufficient permission solution: 1. view the current scott user permission select * from session_privs; -- check whether the result contains Cres.

An error occurred while creating the view for scott users in ORACLE:

Create or replace noforce view classes_view
AS
SELECT * FROM classes; -- create view statement

Row 3 has an error:
ORA-01031: insufficient Permissions

Solution:

1. View scott User Permissions

Select * from session_privs; -- whether the create view permission is available in the result

2. If not, use the administrator user (sys) grant permission.

Window key + R open the run Window input: sqlplus/as sysdba

Grant create view to scott

Authorization successful.