9 May 23:28
Netbeans - problem with changing database user_name (role)
From: achillies_sez <connoisseur_jbsv <at> yahoo.com>
Subject: Netbeans - problem with changing database user_name (role)
Newsgroups: gmane.comp.java.ide.netbeans.user
Date: 2008-05-09 21:28:58 GMT
Subject: Netbeans - problem with changing database user_name (role)
Newsgroups: gmane.comp.java.ide.netbeans.user
Date: 2008-05-09 21:28:58 GMT
I recently came across a problem with netbeans when i tried to change my db role (username and password). i created a few tables with scott as a username in SCOTT schema. every time i created a new table, i run a command which grants access to another user 'sfw_user'(insert,update. select, delete). The problem is when i use the new role to insert or update rows into the table from a web page, it gives me an error ...UPDATE_ROW_CONFLICT row 0 ORA-00942:... But when i use the insert query in netbeans editor, it seems to work fine. I am assuming that the problem is with privileges, 'cause it seems to work fine when i change the role to scott in context.xml. can you advise me how to go about it. i googled for the problem, with no results. any help would be much appreciated. gade. -- -- View this message in context: http://www.nabble.com/Netbeans---problem-with-changing-database-user_name-%28role%29-tp17156694p17156694.html Sent from the Netbeans - Users mailing list archive at Nabble.com.
RSS Feed