No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>Search

Reminder

To have a better experience, please upgrade your IE browser.

upgrade

CloudEC V600R019C00 Security Maintenance (Enterprise On-premises, Only Conference)

Rate and give feedback:
Huawei uses machine translation combined with human proofreading to translate this document to different languages in order to help you better understand the content of this document. Note: Even the most advanced machine translation cannot match the quality of professional translators. Huawei shall not bear any responsibility for translation accuracy and it is recommended that you refer to the English document (a link for which has been provided).
Security Maintenance for the SQL Server

Security Maintenance for the SQL Server

Creating a Maintenance Account

The database administrator must assign accounts to maintenance personnel based on their roles to prevent maintenance personnel from sharing accounts. The accounts and account information storage paths vary with applications.

The sa account has the highest database operation rights and can be used to create, start, stop, back up, and restore databases. The database administrator needs to assign rights to advanced database management accounts independently.

NOTE:
This topic takes the uc account as an example.

The database administrator can create maintenance accounts based on the site's scenario.

The operation procedure is as follows:

  1. Log in to the SQL Server Management Studio as the sa user.
  2. Choose Security > Logins and choose New Login from the shortcut menu.

    The Login - New dialog box is displayed.

  3. Enter account information and select a server role as prompted.
  4. Click OK.

Deleting an Account

To improve application system access security, the database administrator can delete accounts that are not used any more.

The operation procedure is as follows:

  1. Log in to the SQL Server Management Studio as the sa user.
  2. Choose Security > Logins and right-click uc.
  3. Choose Delete on the displayed shortcut menu.
  4. Click OK.

Changing Account Rights

The database administrator can change account rights by changing server roles.

The operation procedure is as follows:

  1. Log in to the SQL Server Management Studio as the sa user.
  2. Choose Security > Logins and double-click uc.
  3. Click the Server Roles tab on the Login Properties page, and select or deselect server roles to change account rights.
  4. Click OK.

Enabling and Disabling an Account

If an account is not in use temporarily, the database administrator can disable the account and then enable it when necessary.

The operation procedure is as follows:

  1. Log in to the SQL Server Management Studio as the sa user.
  2. Choose Security > Logins and double-click uc.
  3. Click the Status tab on the Login Properties page, and select Enabled or Disabled to enable or disable the uc account.
  4. Click OK.

Changing the Password

If a user forgets the account password or wants to change the password for security reasons, the administrator can reset the password.

NOTE:
Change your password periodically to ensure account security, and passwords must meet complexity requirements.

The operation procedure is as follows:

  1. Log in to the SQL Server Management Studio as the sa user.
  2. Choose Security > Logins and double-click uc.
  3. Click the General tab on the Login Properties page, and enter the new password and confirm password.
  4. Click OK.

Checking Logs

To improve application system security, the database administrator must periodically check database operation records, login information, and right change records in logs.

The operation procedure is as follows:

  1. Log in to the SQL Server Management Studio as the sa user.
  2. Choose Management > SQL Server Logs and double-click the required log file.

    The Log File Viewer dialog box is displayed.

  3. Check log information.
  4. Click Close.
Translation
Download
Updated: 2019-08-07

Document ID: EDOC1100059091

Views: 16709

Downloads: 9

Average rating:
This Document Applies to these Products
Related Version
Related Documents
Share
Previous Next