Problem: After using Scott to log in to Oracle, create a view that says "Insufficient permissions", How to solve?
Reply:
This is because Scott, the account, does not currently have permission to create views. The workarounds are:
First sign in with the system account, where "Tigertiger" is the password (modifiable) specified when installing Oracle:
Sqlplus System/tigertiger
Then execute:
Grant create any view to Scott
Tip: Authorization is successful.
Perform:
Exit
Exit the current system account.
You can then use Sqlplus login to create a view, such as:
Sqlplus Scott/tigert
Create a simple view below:
Create or Replace View V1
As
SELECT * from T1;
Sometimes the above method does not solve the problem, use the following method:
--Create View permissions, generally on the internet to say this sentence, but the light has this sentence can not be created
Grant CREATE view to B;
--Grant Query permissions
Grant Select any table to B;
--Grant Permissions
Grant Select any dictionary to B;
Appendix: If the above methods do not solve your problem, you can try the following methods. Anyway my problem is solved, record down. I look for a long day;
Describe:
Same database: DB1
Two custom users: USER1, USER2, respectively
Create a view in USER1 that tries to include the table in USER2. Prompt "Insufficient permissions"
Execute the following SQL, depending on your user needs to modify the use:
--Authorized for 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;
--Authorized for 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;
Oracle CREATE view shows no permissions