SQL Server database security management

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!