SQL Server Security Mechanism

Security is the protection of information through some principals.

  • Authentication is the process of logging on to SQL Server by which a principal requests access by submitting credentials that the server evaluates. Authentication establishes the identity of the user or process being authenticated.

            Authentication means “who you are”.

  • Authorization is the process of determining which securable resources a principal can access, and which operations are allowed for those resources.

            Authorization means “what you can do”.

In SQL Server supports four types security levels.

  1. Windows level security.
  2. SQL Server Instance level security.
  3. Database level security.
  4. Schema level Security.

To get more information about SQL Server Security Mechanism, download the below link.

security_mechanism_in_sql_server_1

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s