EXECUTE permission denied on object 'xp_sqljdbc_xa_recover', database 'master', owner 'dbo'.

Posted on 2011-05-10
Last Modified: 2012-06-21
Hi all,
I'm getting the below exception

Exception is: EXECUTE permission denied on object 'xp_sqljdbc_xa_recover', database 'master', owner 'dbo'.

How to resolve this
Question by:msdba
    LVL 142

    Accepted Solution

    GRANT EXECUTE ON xp_sqljdbc_xa_recover TO application login's user name in master db
    LVL 4

    Assisted Solution

    Looks like the Login needs to have Execute privileges on the extended stored proceudre

    grant execute on xp_sqljdbc_xa_forget to [UserName]


    Author Closing Comment


    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
    Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now