user Archives - SQLChamp

SQL for Beginners

What do you mean by Principals? (with respect to SQL Server)

March 20, 2013 Sarabpreet Singh Anand INFORMATION_SCHEMA, login, principal, security, SQL, SQLServer, user

Principals are entities who can request access on SQL Server Resources on different levels, in other words the entities to

Learn SQL Server User Impersonation

January 17, 2013 Sarabpreet Singh Anand 15517, check permission, Error, Execute As, grant, grant impersonate, granular permission, impersonation, learn, Msg 15517, security, server_principals, SQL, sys.database_principals, user

As discussed in earlier Login Impersonation Blog Technically SQL Server and windows both can be configured to authenticate to another