SQL Server Security Configuration

Added a logon trigger that denys (rollsback) any connection to a Server Role: sysadmin account when connecting from an IP address not listed in the [FriedParts].[dbo].[user-ValidIP] table. The entry "" is the token for the machine physically hosting the SQL Server. All other accounts with permissions on FriedParts either have no rights or are members of "sysadmin" so that the logon trigger will protect them.

User account FP_User has no permissions on the database except "SELECT" on the [view-CadAltium] table. That is, it is a read-only account.