Sorry I'm posting this topic under SQL Server 2008 - General, but I couldn't find a SQL Server 2008 - Security forum section.
When installing SQL Server 2008 on one of our servers, there is an option of giving SQL Server administrative privileges to any Windows user. I provided the local administrator account under this section, as a result of which I'm able to access and make DDL modifications on all databases.
Since I now have to share the local administrator password with another person, and I would therefore like to restrict the local administrator's access to db_datareader.
I tried doing this under Databases > Security > Users, but even after modifying access to the user, I'm still able to create/delete tables.
I also tried doing this under Server Security > Logins, but I couldn't find the user here. I also looked for any of the user groups, but the Administrator account is not present in any of the user groups.
I also modified access on the global level (right-clicking on the server name > Properties and Security), but I'm still able to create/delete tables.
Any idea what I must do to restrict access to the local administrator? Kindly revert.