Grant error on stored procedure 1

[RobHVB6Sql]

I am having problems with one stored procedure, all others are fine.

The normal process is:
1) I (logged in as 'rob' and the db_owner) create a stored procedure.
2) This statement is run:
'GRANT EXECUTE ON rob.spXXX TO EnigmaGroup'
3) Members of the group can run the sp.

Problem is the latest sp created won't allow members to execute it. The error message show is: 'Grantor does not have grant permission'.

The server owner (sysadmin role) has looked at this and run the script, grant statement. We have also tried recreating the script. Could it be a setting in the database? Any hints appreciated. Rob Hasard
Data Manager -Genetic Services
(VB6 /SQL 7.0)

 

[Patrick2002]

Maybe your "problem SP" needs access to objects for which you do not have grant privileges ? Consult BOL on topic "Using ownership chains". Hope you find what you're looking for. Greetz, Patrick