permission over excute SP

Hi Friends,
I want to create an DB_role with the target to give the excute SP
permission to some users and when i create a new SP these users acquires the
permission over the new SP.
A lot of thanks for our possible help.
WalidI don't personally use this method, but you could try adding the stored
procs to a schema and granting the database role containing your users
execute permissions on the schema. That way, any new stored proc would be
added to the same schema and the users inherit exec permission.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .|||Using SQL Server 2005 this is GRANT EXECUTE TO [SomeUser]
HTH, jens K. Suessmeyer.
--
http://www.sqlserver2005.de
--