• You know, it really depends on the shop -- how job duties are divided. In small shops, sometimes the developer and DBA are the same person.

    The best practice would be for developers to ask the DBA to create the new objects and restrict the rights of the developers.

    Aunt Kathi Data Platform MVP
    Author of Expert T-SQL Window Functions
    Simple-Talk Editor