I have a developer who wants to do his job but I have a manger who does not want him to have the db_owner role. What is the best way to give him privileges? I ran GRANT CREATE PROCEDURE TO [user]GRANT ALTER ON SCHEMA::dbo to [user] Now he has come back to want to create/execute functions. What do I do to grant him enough to do his job? Is there a recommendation as to what to grant a developer? Is there a generic script out there?