• Then I suggest that you may use GRANT statement that is more granular then ddladmin. You can look up the syntax in BooksOnline searching for the keyword GRANT. It will give you the ability to grant specific permissions like GRANT CREATE PROCEDURE TO YOUSQLUSER

    Let me know if you need help with writing and executing statements. Please, try it first on the test database like Northwind or Pubs

    Regards,Yelena Varsha