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

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

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.