I know in sql 2000, in order to grant 'Execute' permission on all sps, functions and etc to a DB role, we have to first create a cursor, and run the grant statement to each DB object. I read an article recently talking about granting 'EXECUTE' on all sps, functions and etc to a DB role, it said SQL 2005 makes EXECUTE grantable at the database scope. Example like we can issue the below script and this will grant execute permissions on all existing stored procedures and scalar functions AND all subsequently created ones within the MyDB to the DB role. Use MyDB Create Role DB_executor Grant EXECUTE to DB_executor Now the role DB_executor has EXECUTE permission on all sps, all scalar functions and all subsequently created ones in MyDB. I searched a while on SQL 2K5 BOL, trying to find some definitive words regarding this, while I could not find it. I post here just want to confirm with you guys about the correctness about this. thanks.