Security and XA permissions [message #162491] |
Fri, 10 March 2006 09:49 |
mjschwenger
Messages: 137 Registered: July 2005 Location: US
|
Senior Member |
|
|
I'm running an app which uses WebSphere Application Server.
I start getting the errors bellow. The solution pointed in Note:308234.1 is to give WebSphere Application Server transaction service special permissions for performing transaction recoveries like:
grant select on v$xatrans$ to public (or <user>);
grant select on pending_trans$ to public;
grant select on dba_2pc_pending to public
grant select on dba_pending_transactions to public
grant execute on dbms_system to <user>;
OK, but now, there is huge discussion if this is appropriate from security/auditing point of view.
I'm wondering if somebody has experience to share for the security problem.(if a problem at all)
Also, can I stop the transaction recovery from within WebSphere, so I'll stop getting the application errors? At the end, do I need it at all?
Thanks lot, mj
|
|
|