Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

To support a developer who is testing his application on an Oracle 12c database, has requested the following for two users:

  • USER0 who is permitted to start XA transactions and do crashrecovery.

and

  • USER1 who is permitted to start XA transaction but is not permitted to do crash recovery

I have not worked extensively with oracle and I am having a hard time tracking down how to honour this request. Any pointers or references would be appreciated.

Late Edit: For our purposes the solution was to do the following to allow the above:

SQL> GRANT SELECT on sys.dba_pending_transactions to USER1;
SQL> GRANT SELECT on sys.pending_trans$ to USER1;
SQL> GRANT SELECT on sys.dba_2pc_pending to USER1;
SQL> 
SQL> GRANT SELECT on sys.dba_pending_transactions to USER0;
SQL> GRANT SELECT on sys.pending_trans$ to USER0;
SQL> GRANT SELECT on sys.dba_2pc_pending to USER0;
SQL> GRANT EXECUTE ON sys.dbms_xa TO USER0;
SQL> GRANT EXECUTE ON sys.dbms_system TO USER0;
share|improve this question
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.