EXECUTE on everything.

SQL2000.
Does anybody know if it is possible to effectively grant execute on all
stored procedures within a database, without giving people db_owner
rights?
I'm possibly misreading BOL but there doesn't appear to be the equivalent
of GRANT EXECUTE ON ALL PROCEDURES TO databaseusers
TIA.You can run this sql and then run the output...
SELECT 'GRANT EXECUTE ON ' + name + ' TO someuser' FROM sysobjects WHERE TYPE =3D 'p'
-- Keith
"Stressed" <k@.c.co.uk> wrote in message =news:#HZbvuvcDHA.2404@.TK2MSFTNGP10.phx.gbl...
> SQL2000.
> > Does anybody know if it is possible to effectively grant execute on =all
> stored procedures within a database, without giving people db_owner
> rights?
> > I'm possibly misreading BOL but there doesn't appear to be the =equivalent
> of GRANT EXECUTE ON ALL PROCEDURES TO databaseusers
> > TIA.
> >