achillies_sez | 9 May 23:28
Picon
Favicon

Netbeans - problem with changing database user_name (role)


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.


Gmane