Permission problem of SqlServer

The permission level of these two methods is the same. You should read more books instead of asking about this knowledge. LJ knows that the above answers are really pleasing, especially the so-called high-quality questions and answers.

The permission level of Sa is sysadmin, which is the largest permission level in the whole sqlserver. The biggest difference between windows permissions and sa login is actually authentication, one is authenticated by windows, and the other is authenticated by sqlserver account password. In sqlserver, Windows authentication is granted permissions according to sysadmin.

For example, in ancient times, the emperor could not always be the same person. Sa's theme is national law, locked in a safe. Sa's password is a password. No matter which Tom, Dick and Harry know the password, they can get the decree. Then both ministers and generals (they are sqlserver, the real command executors) will admit that he is the emperor and will act according to his orders.

If you enter the answer by hand, please get out if you plagiarize (LeTV) or attack (Big Wave).

What are windows permissions? To put it bluntly, these ministers and generals authorized the windows subject (similar to the so-called Buddhism in ancient times, or fortune telling) to verify the identity of Tom, dick and Harry, but they unconditionally believed the results of windows authority verification; As long as the fortune tellers say that Tom, dick and Harry are emperors, they will do whatever Tom, dick and Harry say, regardless of whether the national laws are passed or not. Treat him like an emperor.