sql - User can create but not execute stored procedure -

problem

i have sql server login allowed create stored procedures, not execute them. cannot use login grant execute looking alternative way either run code in sp or grant these permissions.

the execute permission denied on object 'sp_mystoredprocedurename', database 'mydatabasename', schema 'dbo'.

the user cannot grant execute itself

cannot grant, deny, or revoke permissions sa, dbo, entity owner, information_schema, sys, or yourself.

background

we have windows software application, written in powerbuilder, creates , updates sql server database works on itself.

on first startup application prompts database admin login uses 1 time (we don't store information) create database , login. login given db_ddladmin, db_datareader , db_datawriter permissions. have hundreds of these applications , databases running on servers managed us, on our customers' own servers.

for reason prevent need ask user db admin login again can grant execute permissions, easiest way... downgrading servers sql server 2000 of course not option :)

the stored procedure trying implement "getnewid" method. powerbuilder code uses multiple embedded tsql statements achieve because of network performance issues move these single stored procedure.

does ?

create role db_executer grant execute db_executer exec sp_addrolemember n'db_executer', n'<username>'