SQL Server Database Security Management Introduction _mssql2005

For database applications, the security of the database is critical. SQL Server's security features protect your data from unauthorized leaks and tampering! Below is a summary of the security chapter!

First, some summary of the security Object! Let's look at this picture:

Here I give you the details of fixed server roles and fixed database roles!

1, fixed server role:

2, fixed database role:

Of course, with this knowledge base, how do we manage these security projects?

1, let's look at the setup of our verification mode,

2, the user login name management settings:

3.1 Settings for roles (Object Explorer):

3.2, role management settings (T-SQL statements):

4. The settings for managing permissions (object Manager) and administrative roles are roughly the same, where I put the method of using T-SQL statements:

Best of all, as long as we use these security settings, our database data will be very safe and reliable! Can help us avoid a lot of unnecessary trouble!