资源描述:
《外文文献—web环境下sql server数据库安全策略研究》由会员上传分享,免费在线阅读,更多相关内容在行业资料-天天文库。
1、附录一WEBenvironmentSQLServerdatabasesecuritystrategyresearchAlongwiththedevelopmentoftheInternetnetworkandexpands,moreandmoreapplicationsystemusesWindowsseriesofoperatingsystemastheServer,SQLServerforthebackeddatabaseServer.AccordingtoWEBenvironmentSQLServervarioussecurityproblemsar
2、eanalyzed,andtheeffectivesolution.Keywords:WEBSQLServerdatabasesecuritystrategyMicrosoftSQLserversecurityinvolveduserconfigurationidandpassword,auditsystem,prioritymodelandcontrolofthedatabasedirectoryspecialpermission,built-incommand,scriptandprogramminglanguage,networkprotocol,p
3、atchandservicepack,databasemanagementutilityanddevelopmenttool.InthedesignofSQLServerdatabase,wanttoconsiderthedatabasesecuritymechanism,wheninstallationshouldpayattentiontomoreofthewholesystemsecuritySettings.Startingfromthefirstoperatingsystem,wanttoundertaketherightsecuritySett
4、ings,clearoperatingsystemuserpermissions,usingfiledriverfileoperationstofilter,thedatabaselibraries,logfiles,suchasbackupfiletheoperationoflimitedaccesstodatabaseprocessandspecifiedprocesstooperation,theprocessbyotheroperationwillfail.1SQLServerdatabaseaccesscontrolstrategySQLServ
5、erareusuallyinstalledinNTFS,NTFSthanFATfilesystemmorestableandmoreeasytorecover,cantofile,folderACLandfileencryption(EFS)setting,etc.ThroughthedatabasefileswillbeEFSoperationSQLServeraccountundertheidentityforencryption,andonlytheaccounttodecryptthedocuments.1.1Thepasswordsecurity
6、strategySecuritypassworddatabasemanagementstrategyisthefirststepofconfiguringsecurity,don'tletsaaccountpasswordwritteninapplicationorscripts.SQLServer2000installation,ifistousemixedmodel,thenneedtoentersapassword,theproposaldoesnotuseemptypasswordandregularlychangethepassword.Data
7、baseadministratorsshouldbeperiodicallytocheckwhetherthereisnotinconformitywiththerequirementsoftheaccountpassword.1.2ThesecurityoftheaccountstrategyThedatabasesecuritynotonlytopreventsensitivedataisspyon,andtopreventanyinterferenceusersthedatabaseoftheoperation.Thedatabasesystemsa
8、fetymanagementofthefirststepisint