Home > Uncategorized > The EXECUTE permission was denied on the object ‘XXObject’ database ‘XXDatabase’, schema ‘XXschema’.

The EXECUTE permission was denied on the object ‘XXObject’ database ‘XXDatabase’, schema ‘XXschema’.

In a recent build, we have got the following error.

The EXECUTE permission was denied on the object ‘XXObject’ database ‘XXDatabase’, schema ‘XXschema’.

Instead of granting the execute on just one object I started researching more.

Because it might be just temp fix and you want to find the root cause.

It looks like the user was able to execute all of the procedures before and now unable to execute any.

So the permanent solution is

GRANT EXECUTE ON SCHEMA::XXschema TO XXuser

Advertisements
Categories: Uncategorized
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: