Oracle Sql Error 1031 Sqlstate 42000
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a sql error 904 title. You can not post a blank message. Please type your message and ora-01031 try again. More discussions in Data Integrator All PlacesBusiness IntelligenceSystem Management and IntegrationData Integrator This discussion is archived 10 Replies Latest reply on Oct 7, 2011 8:28 AM by 844525 1031 : 42000 : java.sql.SQLException: ORA-01031: insufficient privileges 798219 Sep 16, 2010 11:16 AM Good day, I'm trying to run an interface wherein the data coming from a csv file should be loaded in one target table. I managed to reverse engineer the flat file and map all fields. But come execution, i get this error message: 1031 : 42000 : java.sql.SQLException: ORA-01031: insufficient privileges java.sql.SQLException: ORA-01031: insufficient privileges I have already granted alter and insert access to the user. Thanks in advance 3959Views Tags: none (add) This content has been marked as final. Show 10 replies 1. Re: 1031 : 42000 : java.sql.SQLException: ORA-01031: insufficient privileges Sutirtha Roy Sep 16, 2010 11:21 AM (in response to 798219) Do your work schema user has proper privilege ? Like Show 0 Likes(0) Actions 2. Re: 1031 : 42000 : java.sql.SQLException: ORA-01031: insufficient privileges 798219 Sep 16, 2010 11:28 AM (in response to Sutirtha Roy) Thank you Sutirtha Roy for your response. Yes. My Schema and work schema are the same. Both have already been granted Like Show 0 Likes(0) Actions 3. Re: 1031 : 42000 : java.sql.SQLException: ORA-01031: insufficient privileges Sutirtha Roy Sep 16, 2010 11:30 AM (in response to 798219) In that case can you copy/paste the failing code here from operator ? Thanks, Sutirtha Like Show 0 Likes(0) Actions 4. Re: 1031 : 42000 : java.sql.SQLException: ORA-01031: insufficient privileges 798219 Sep 16, 2010 11:33 AM (in response to Sutirtha Roy) Here is the complete error code: 1031 : 42000 : java.sql.SQLException: ORA-01031: insufficient privileges java.sql.SQLException: ORA-01031: insufficient privileges at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282) at oracle.jdbc.driver.T4C8O
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack https://community.oracle.com/thread/1131865 Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Hibernate native SQL error up vote 5 down vote favorite I am trying to execute sql native query using hibernate 3.3.2.GA. I have following query. session.createSQLQuery("SELECT {dept1.*}, {dept2.*} http://stackoverflow.com/questions/4548735/hibernate-native-sql-error FROM Dept d1, Dept d2 WHERE d1.deptId = d2.deptId"). addEntity("dept1",com.test.pojo.Dept.class). addEntity("dept2",com.test.pojo.Dept.class). list(); Mapping file for Dept class is
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the http://stackoverflow.com/questions/140643/ora-01031-insufficient-privileges-when-selecting-view workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions http://it.toolbox.com/blogs/david/ora01031-insufficient-privileges-upon-instance-startup-13759 Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join sql error them; it only takes a minute: Sign up ORA-01031: insufficient privileges when selecting view up vote 25 down vote favorite 6 When I try to execute a view that includes tables from different schemas an ORA-001031 Insufficient privileges is thrown. These tables have execute permission for the schema where the view was created. If I execute the view's SQL oracle sql error Statement it works. What am I missing? oracle view share|improve this question asked Sep 26 '08 at 16:47 Igor Zelaya 2,65842344 add a comment| 7 Answers 7 active oldest votes up vote 17 down vote accepted As the table owner you need to grant SELECT access on the underlying tables to the user you are running the SELECT statement as. grant SELECT on TABLE_NAME to READ_USERNAME; share|improve this answer answered Sep 26 '08 at 16:53 Steve K 14.5k43746 add a comment| up vote 32 down vote Finally I got it to work. Steve's answer is right but not for all cases. It fails when that view is being executed from a third schema. For that to work you have to add the grant option: GRANT SELECT ON [TABLE_NAME] TO [READ_USERNAME] WITH GRANT OPTION; That way, [READ_USERNAME] can also grant select privilege over the view to another schema share|improve this answer answered Sep 26 '08 at 18:47 Igor Zelaya 2,65842344 What if dba grants the priviledge. I am not getting this work although us
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries VoIP_News Inside-ERP MacProTX Inside-CRM I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre Craig Borysowich Locutus Dennis Stevenson DukeGanote Richard iudithm mircea_luca Clinton Jones bracke Nikki Klein AbhaiTripathi Iqbalyk Adrian_Grigoriu bluesguyAZ59 numbersguyPA COMPANIES EdgeWave Sophos Pivotal CRM Wave Direct View All Topics View All Members View All Companies Toolbox for IT Topics Database Blogs ORA-01031: insufficient privileges upon instance startup David Yahalom Jan 4, 2007 | Comments (54) Tweet 0 Please Sign In or Register to like this blog. A friend of mine who is a junior DBA approached me today with a strange problem that was bugging him for hours. He installed a new Windows Oracle 9i server and wanted to create the databases manually (something I always recommend over DBCA, as you get finger grain control over your database creation process and you feel more "in control" of whats going on inside your DB). He created an init.ora file for his Instance and since he wanted to use OS authentication for Oracle, he left the parameter remote_login_passwordfile to its default value ("none"). He then proceeded to creating his instance using the following command: oradim -new -sid InstanceSID -startmode m -pfile C:\location_to_pfile\init.ora -intpwd password After which, the instance was created. He proceeded to creating the database itself. Since he was all keen about doing this manually he opened up a Windows CMD and did the following steps: C:> SET ORACLE_SID=InstanceSID
C:> sqlplus /nolog
SQL*Plus: Release 9.2.0.1.0 - Production on Wed