For database applications, database security is crucial. SQL Server's security function can protect data from unauthorized leaks and tampering! Below is a summary of the security chapter!
The first is a summary of the security object! Let's take a look at this figure:
Here I will give you details about the fixed server role and the fixed database role!
1. Fixed server roles:
2. Fixed database roles:
Of course, with this knowledge base, how can we manage these security projects?
1. Let's take a look at the settings of the Verification Mode,
2. Management settings for user login names:
3.1 Role settings (Object Resource Manager ):
3.2 role management settings (T-SQL statements ):
4. The setting of administrative permissions (Object Manager) is roughly the same as the method of managing roles, here I will talk about the method of using the T-SQL statement:
Best, as long as we have used these security item settings, our database data will be very safe and reliable! This helps us avoid unnecessary troubles!