InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 18:36:53 GMT20http://www.sqlservercentral.com/Forums/Topic605303-359-1.aspxHi,I wonder if you could clarify for me that if i provide a programmer DDL_Admin on a database does this allow them to execute a stored procedure that they have just created against the database they are mapped to with DDL_Admin permissions.Only it gives them pretty much all they need i.e.Members of the db_ddladmin fixed database role can run any Data Definition Language (DDL) command in a database. Yet i still have to explicitly grant them Execute permissions on the their SP.Your help would be greatly appreciated.:-)Mon, 05 Nov 2012 10:06:33 GMTextremenovicehttp://www.sqlservercentral.com/Forums/Topic605303-359-1.aspxBooks Online should be able to answer all your questions about the fixed server and database roles.Thu, 20 Nov 2008 09:38:09 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic605303-359-1.aspxI was just trying to find out all the diffeerences between ddladmin and dbowner.Thu, 20 Nov 2008 09:36:04 GMTMike Levanhttp://www.sqlservercentral.com/Forums/Topic605303-359-1.aspxFrom Books Online (BOL) :[quote]Members of the db_ddladmin fixed database role can run any Data Definition Language (DDL) command in a database. [/quote]So, answer, yes.Wed, 19 Nov 2008 11:36:42 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic605303-359-1.aspxcan ddladmin role create tables in a DB?Wed, 19 Nov 2008 11:13:44 GMTMike Levan