What are security principals?

What are security principals?

Rating:

Security principals include the objects such as users, logins, groups and roles. These objects use the database to store and retrieve data as per the permissions granted to them. Groups and roles also contain other security principals so they can also be termed as collections. Security principals exists at three levels as follows:

• Windows level: It includes Windows domain logins, Windows local logins and Windows groups.


• SQL Server level: It includes SQL Server logins and roles.


• Database level: It includes database users, application roles, and database roles.

Rating: