SCENARIO: Developers do not have write access on the production databases all there changes needs to go through the DBA who will execute their scripts, but on the one database they have access to create and truncate tables(write access).I went through the logons of the database and their is a user group which has the ddl_admin writes. I know the ddladmin write gives write access as well to the database.
Here is the Confusion: The user group only exists under the DATABASE->USERS tab but does not exist under the SECURITY->LOGIN tab
how is that possible, can that logon still work if not how is it possible for them to write to the database