The EXECUTE permission was denied on the object ...

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace, andy.campbell.smith

The EXECUTE permission was denied on the object ...

Postby adster » Thu Jul 25, 2013 12:35 pm

The EXECUTE permission was denied on the object 'RG_ProcVersion', database 'tempdb', schema 'dbo'.

I'm getting the above error when trying view "Commit Changes" on one of our database instances.

Its not a DB permissions problem because I can access it fine from any other workstation using the same credentials. I can also access any of our our other instances without any problems from my machine.

I've updated to the latest version of the software but it has made no difference.

Does anyone have any ideas?

thanks
adster
 
Posts: 2
Joined: Thu Jul 25, 2013 12:27 pm

Postby eddie davis » Mon Jul 29, 2013 1:57 pm

Hi, thank you for your forum post.

I suspect that the SQL Server is unable to authenticate the account when the account is logged in to this workstation.

The fact that you can connect and access from other workstations using the same account with no problems, suggests that the problem is with the workstation and not the SQL Server Instance where 'RG_ProcVersion' function is installed.

Are you able to use SSMS and locate the 'RG_ProcVersion' function in the 'tempdb' database?

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Postby adster » Tue Jul 30, 2013 10:53 am

Thanks for the help Eddie. It proved the starting point to fixing it by comparing it to the other instance.

Relaying what our DB guys have told me in the hope it helps others. "We dropped the schema and then removed public access to tempdb"
adster
 
Posts: 2
Joined: Thu Jul 25, 2013 12:27 pm


Return to SQL Source Control 3

Who is online

Users browsing this forum: No registered users and 0 guests