You are not authorized to create a view in Oracle. You are authorized to create a view in oracle.

You are not authorized to create a view in Oracle. You are authorized to create a view in oracle.

Q: After using scott to log on to Oracle, the system creates a view and prompts "insufficient Permissions". How can this problem be solved?
Answer:
This is because scott has no permission to create a view. Solution:
First, use the system account to log on. "tigertiger" indicates the password specified during Oracle Installation (which can be modified ):
Sqlplus system/tigertiger
Then execute:
Grant create any view to scott
Prompt: Authorization successful.
Run:
Exit
Exit the current system account.

Use sqlplus to log on to create a view, for example:
Sqlplus scott/tigert
Create a simple view as follows:
Create or replace view v1
As
Select * from t1;

 

Sometimes the above method still cannot solve the problem, use the following method:

-- Create view permission. Generally, this statement is used for searching on the Internet, but it still cannot be created.
Grant create view to B;

-- Grant query permission
Grant select any table to B;

-- Grant Permissions
Grant select any dictionary to B;

Appendix: if the above method cannot solve your problem, try the following method. My problem is solved. record it. I am looking for more than half a day;

 

Description:

Same Database: DB1

Two Custom Users: USER1 and USER2

Create a view in USER1 and try to include the table in user2. The system prompts "insufficient Permissions"

Run the following SQL statement to modify and use the statement as needed:

-- Authorize USER1

Grant create any table to USER1;
Grant select any table to USER1;
Grant comment any table to USER1;
Grant lock any table to USER1;
Grant select any dictionary to USER1;

 

-- Authorize USER2

Grant create any table to USER2;
Grant select any table to USER2;
Grant comment any table to USER2;
Grant lock any table to USER2;
Grant select any dictionary to USER2;