Cov txheej txheem:

Dab tsi yog ob qhov tseem ceeb ntawm kev sau ntawv SQL Server tshawb xyuas rau Windows kev ruaj ntseg cav?
Dab tsi yog ob qhov tseem ceeb ntawm kev sau ntawv SQL Server tshawb xyuas rau Windows kev ruaj ntseg cav?

Video: Dab tsi yog ob qhov tseem ceeb ntawm kev sau ntawv SQL Server tshawb xyuas rau Windows kev ruaj ntseg cav?

Video: Dab tsi yog ob qhov tseem ceeb ntawm kev sau ntawv SQL Server tshawb xyuas rau Windows kev ruaj ntseg cav?
Video: Kev Muag Khoom thiab Kev Sib Cuam Tshuam Nrog Cov Neeg Qhua Yam Muaj Kev Nyab Xeeb 2024, Kaum ib hlis
Anonim

Muaj ob txoj cai tseem ceeb rau kev sau ntawv SQL Server server tshawb xyuas rau Windows Security log:

  • Cov kev tshuaj xyuas object access setting yuav tsum configured mus ntes cov xwm txheej.
  • Tus account uas tus SQL Server kev pabcuam yog khiav hauv qab yuav tsum muaj cov generate kev soj ntsuam kev ruaj ntseg kev tso cai sau mus rau Windows Security log .

Tib neeg kuj nug, Kuv yuav ua li cas thiaj paub yog tias SQL Server tshawb xyuas tau qhib?

Saib SQL Server Audit Logs

  1. Hauv SQL Server Management Studio, hauv Object Explorer vaj huam sib luag, nthuav Kev Ruaj Ntseg thiab.
  2. Txoj cai-nias ntawm cov khoom tshawb xyuas uas koj xav pom thiab xaiv Saib Cov Ntawv Teev Npe ntawm cov ntawv qhia zaub mov.
  3. Nyob rau hauv Log File Viewer, cov cav yuav tshwm nyob rau sab xis.

Ib tug kuj yuav nug, Kuv yuav ua li cas thiaj li pab tau SQL auditing? Txhawm rau txhawm rau txheeb xyuas ntawm SQL Server:

  1. Nkag mus rau Registered SQL Servers nyob rau hauv cov ntoo Administration.
  2. Xaiv qhov SQL Server piv txwv uas koj xav kom pab tshawb xyuas.
  3. Nyem Enable Auditing. Qhov kev txiav txim no yuav ua rau muaj kev tshuaj xyuas ntawm cov server thiab qib database.

Ib sab ntawm no, kuv yuav saib SQL audit cav li cas?

Mus saib SQL Server audit log

  1. Hauv Object Explorer, nthuav cov ntaub ntawv Security.
  2. Nthuav lub Audits folder.
  3. Right-click lub audit log uas koj xav mus saib thiab xaiv Saib Audit Logs. Qhov no qhib lub Log File Viewer -server_name dialog box. Yog xav paub ntxiv, saib Log File Viewer F1 Pab.
  4. Thaum tiav lawm, nyem Kaw.

C2 auditing yog dab tsi?

Cov C2 kev soj ntsuam hom siv qhov system-txhais kab ke los sau kev tshuaj xyuas cov ntaub ntawv rau MS SQL Server 2000 thiab siab dua. Nws siv tag nrho cov txheej xwm kev nyab xeeb uas tau teev tseg hauv SQL Server, tsis yog txhua yam uas yuav tsum tau ua los ntawm Database STIG. Tsis xav tau kev tshuaj xyuas , kev lav phib xaub thiab kev tshawb nrhiav kev txhawb nqa yog txwv.

Pom zoo: