Home Forums SQL Server 2005 Administering Multiple logins w. sysadmin (multiple databases/apps)? RE: Multiple logins w. sysadmin (multiple databases/apps)?

  • You cannot lock out a system admin from the other databases. Your better off solving the root problem which is figuring out what access those 2 application accounts really need and removing them from sysadmin. There are several roles that can be granted to the application accounts that will certainly meet the security requirements they need besides making them a system admin.

    Thanks,

    Mike McNeer