x

cannot execute function/stored procedure but can see it

Developer can see a function and store procedure but cannot execute. Any suggestion on how to fix? The developer group they are a member of has the RWX permissions on the database and the two objects.

He gets this error:

The EXECUTE permission was denied on the object 'function_name', database 'db_name', schema 'schema_name'

and

Msg 229, Level 14, State 5, Procedure [stored_procedure_name], Line 1 The EXECUTE permission was denied on the object 'stored_procedure_name', database 'db_name', schema 'schema_name'

more ▼

asked Aug 30, 2011 at 07:42 AM in Default

avatar image

colibri
151 15 15 17

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Have you tried explicitly granting execute permissions on the objects?

 GRANT EXECUTE ON [objectname] TO [Username]

Also check to see if any DENY permissions have been assigned. DENY overrules GRANT permissions.

more ▼

answered Aug 30, 2011 at 07:51 AM

avatar image

WilliamD
26.2k 18 35 48

Yes went through SSMS and granted permissions to the objects through there. Anything else that it could be?

Aug 30, 2011 at 09:55 AM colibri

As I mentioned at the end of my answer, make sure you don't have a DENY assigned to the users, as this will override any GRANT you may have assigned. Also make sure you are in the right database when doing all this, you may be connecting to the user's default DB and that may be different to the DB you are aiming for.

Aug 30, 2011 at 11:48 AM WilliamD
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x472
x119
x71
x12
x12

asked: Aug 30, 2011 at 07:42 AM

Seen: 2804 times

Last Updated: Aug 31, 2011 at 12:38 AM

Copyright 2017 Redgate Software. Privacy Policy