From SQL Srever 2005, Microsoft has introduced the concept of principals. Principal may be a
- Server login (Windows users, Windows security groups, SQL Server log in)
- Database user
Prior to SQL Server 2005 terms logins and users were being used. Now from SQL Server 2005 and onwards terms Server principals and database principals have been introduced.
Server principals include Server logins and roles
Database principals include database logins and roles