Post reply

ddl_admin

  • November 19, 2008 at 11:13 am

    #215532

    can ddladmin role create tables in a DB?

  • November 19, 2008 at 11:36 am

    #900661

    From Books Online (BOL) :

    Members of the db_ddladmin fixed database role can run any Data Definition Language (DDL) command in a database.

    So, answer, yes.

  • November 20, 2008 at 9:36 am

    #901136

    I was just trying to find out all the diffeerences between ddladmin and dbowner.

  • November 20, 2008 at 9:38 am

    #901139

    Books Online should be able to answer all your questions about the fixed server and database roles.

  • November 5, 2012 at 10:06 am

    #1556137

    Hi,

    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.

    🙂

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply