The original poster in Imp import data to the oracle database, found that has failed to import all the views, view the log, originally is the permission problems, should be to do not have permission to create the view, had been given permission to import users connect and resources, Google search related information, in a blog post to see the connect permissions for
ALTER SESSION - modify SESSION
The CREATE CLUSTER - based clustering
The CREATE DATABASE LINK, establish a DATABASE LINK
The CREATE SEQUENCE in order to build a SEQUENCE
The CREATE SESSION - establish SESSION
CREATE SYNONYM - synonyms
The CREATE VIEW - based VIEW
Actually has the authority to create a view, then the database through the select * from role_role_privs; To find the role authorization, found the connect only the create session permissions, continue to Google, at https://www.safaribooksonline.com/library/view/oracle-security/1565924509/ch05s02.html find relevant specification, after oracle6, connect these new permissions, and this is not the same with the original poster on database search, so confused, what want to consult the connect privileges?

CodePudding user response:

ALTER SESSION - modify SESSION
The CREATE CLUSTER - based clustering
The CREATE DATABASE LINK, establish a DATABASE LINK
The CREATE SEQUENCE in order to build a SEQUENCE
The CREATE SESSION - establish SESSION
CREATE SYNONYM - synonyms
The CREATE VIEW - based VIEW


Or permissions problem, isn't it across user?

CodePudding user response:

No, has been operating under the same user

CodePudding user response:

Problem has been solved, to find an answer on stackoverfolw http://stackoverflow.com/questions/27100363/what-is-the-significance-of-connect-role-in-oracle, created in the oracle6 connect these permissions, and in oracle10g made changes again, to remove additional permissions, only retained the create
The session the permissions,

CodePudding user response:

In fact, have no legal power to empowerment manually, do you want to check the reason well it need you to this spirit of scholarship

CodePudding user response:

reference 4 floor js14982 response:

in fact, have no legal power to empowerment manually, do you want to check the reason well it needs this spirit of scholarship you

I was just at the rookie, still a lot of things to learn, thank you or elder encouraged,

CodePudding user response:

 
Select * from dba_sys_privs where grantee='CONNECT' 

CodePudding user response:

 select * from dba_sys_privs where grantee='connect'; 
GRANTEE PRIVILEGE ADMIN_OPTION 
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- 

SQL> Select * from role_sys_privs where role='resource'; 
ROLE PRIVILEGE ADMIN_OPTION 
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- 

The actual query result is such, don't know why, but through the select * from dba_sys_privs query is the result