:::: MENU ::::

Principals in SQL Server 2005,SQL Server 2008

  • Jan 28 / 2009
  • 0
dbDigger, Logins and Users, Security and Permissions

Principals in SQL Server 2005,SQL Server 2008

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
  • Role

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

Consult us to explore the Databases. Contact us