Home » RDBMS Server » Security » Security and XA permissions
Security and XA permissions [message #162491] Fri, 10 March 2006 09:49
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
Previous Topic: Column Masking on Table
Next Topic: SELECT access to VIEWS through ROLES
Goto Forum:

Current Time: Fri Dec 09 03:55:01 CST 2022