Oracle exchange, Tutorial and Training

บทความนี้จะพูดถึง วิธีการเตรียมการป้องกัน Password ของ Oracle ให้มีความปลอดภัยได้อย่างไร

1. Enforce case sensitivity passwords :

          สำหรับ  Oracle database 11g คุณสามารถเลือกให้ Password เป็นแบบ Case – Sensitive   ได้  โดยสามารถกำหนดได้ที่ พารามิเตอร์   SEC_CASE_SENSITIVE_LOGON   ด้วยการใช้ คำสั่ง ALTER   

    ถ้ากำหนดเป็น TRUE หมายความว่า  password เป็นแบบ  Case – Sensitive  

  แต่ถ้ากำหนดเป็น FALSE หมายความว่า password  ไม่เป็นแบบ  Case – Sensitive 

ตัวอย่างคำสั่ง

Alter system set sec_case_sensitive_logon = TRUE

2.Password complexity checking  :  

       เป็นการทำให้ password มีความซับซ้อนเพิ่มขึ้น เพื่อป้องกันการใส่ password โดยการเดาสุ่มจากผู้ไม่ประสงค์ดี 

  ไม่สามารถใช้คำในดิกชันนารี มาเป้น password ได้ 

      สำหรับ Oracle database 11g  คุณสามารถกำหนดให้ User ต้องสร้าง password ที่มีความปลอดภัยมากพอ

   ถึงจะสามารถใช้เป็น password ได้

    Oracle เตรียมฟังก์ชันการตรวจสอบ password  โดย PL/SQL สคริปต์ที่ชื่อว่า UTPLWDMG.SQL  (อยู่ใน in      $ORACLE_HOME/ORACLE_HOME/RDBMS/ADMIN )

  UTPLWDMG.SQL Script ตรวจสอบเงื่อนไขต่อไปนี้  เมื่อ User ทำการสร้างหรือแก้ไข password

     -         ประกอบด้วย ตัวอักษร อย่างน้อย 8 ตัวอักษร และ ไม่มากกว่า 30 ตัวอักษร

     -         ไม่ตรงกันกับชื่อ User

     -         ไม่ตรงกันกับชื่อเครื่อง

     -         ไม่ตรงกันกับคำที่อยู่ใน Dictionary  หรือ  เช่น  welcome1 , oracle123 , oracle user1234 เป็นต้น

     -         ต้องประกอบด้วย ตัวเลขอย่างน้อย 1 ตัวและ ตัวอักษร 1 ตัว

     -         กรณีเปลี่ยน password  password ใหม่ต้องไม่ตรงกับ password เดิมอย่างน้อย 3 ตัว

Ref: Oracleฎ Database Security Guide 11g Release 1 (11.1)

Comments

Add New Search

zjcjy   |125.70.58.xxx |2010-01-09 21:50:58 The Britishladies handbagsembassybrand bagaskedhandbags discountaskedcheap designer handbagsstaffbranded handbagstodesigner handbagsstaydesigners handbagsatdiscounted designer handbagshomediscount designer handbagsoncoach handbagsSundaychanel handbagswell-placedtory burch shoessourcesmanolo blahnik shoestoldjimmy choo sandalslocaljimmy choo shoesNewschristian louboutin priveYemenchristian louboutin pumpscitingysl shoessecurityzanotti shoesreasonsprada messenger bagbehindMiu Miu TotetheMiu Miu Bagclosureprada hoboThePrada ClutchsourcesPrada HandbagdidPrada TotenotChristian Louboutin ShoessayChristian Louboutin Pumpswhenchristian louboutin bootsthechristian louboutin shoes redmissionchristian louboutin redwouldlouboutin shoesbechristian louboutin sandalsreopenedhigh heel pumpsEarlierLove Kills SlowlyhereEd Hardy SkulltoEd Hardy Tiger Shirtme Reply | Quote 0   0

zjcjy   |125.70.58.xxx |2010-01-09 21:53:03 ThemanDesigner clothinghadDesigner replica handbagssomereplica jewelrykindreplica clothingof incendiarydevicereplica handbagsdevicereplica wholesale handbagsheWholesale jewelrytriedReplica rolex watchestoreplica watchesin atimberland bootsbagtimberland shoes bootsstrappedtimberland prototimberland men's bootshisblack timberland bootsbodytimberland euro hikerU.S.women's timberland bootsofficialswomen's timberland boottoldGucci BagNBCgucci hysteriaNewsgucci boston bagOthergucci handbagofficialsGucci HobotoldGucci Messenger BagNBCGucci Shoulder BagstationGucci ToteWDIV Reply | Quote 0   0

zjcjy   |125.70.58.xxx |2010-01-09 21:53:44 ofugg classic tall boots uggDetroit Ugg bootsthatWWomen's ugg bootstheClassic tall uggsdevicediscount ugg bootswasblack classic tall ugg bootsa mixtureugg sandofugg pinkpowderGHD Pinkpowderpink ghd straightenerspowderpink ghd hair straightenerspowderGHD PurpleandGHD KissliquidGHD Pureliquidghd mk4 pinkwhichghd straighteners purplefailedpink ghd hairtoEd Hardy CapswhenEd Hardy ShoetheEd Hardy MenspassengerEd Hardy Womenstried Ed Hardy clothingto detonateed hardy onlineit duringed hardy Appareltheed hardy T-shirtsplane’s Reply | Quote 0   0

zjcjy   |125.70.58.xxx |2010-01-09 21:54:31 descentRay Ban sunglassesintoaviator sunglassesDetroitray ban wayfarerMetropolitanray ban wayfarersWayneray ban 3025Wayneray ban 2140Airportray ban aviator 3025ROMULUSray ban 2132Michjewelry necklacesA Nigerianpandora braceletmanlinks of london bracelettriedlinks of london sweetie bracelettopandora jewellery charmslightjuicy couture braceleta powderpandora charm braceletaboardsilver bracelet pandoracommercial Reply | Quote 0   0

zjcjy   |125.70.58.xxx |2010-01-09 21:55:19 Flighteed hardy dust coatFlightEd Hardy SaleandEd Hardy Clothing11 crewED Hardy KidsmembersED Hardy MensaboardED Hardy WomenswasSunglass Hot Salewascartier sunglass salefroBuy Ray banthereplica louis handbagsairportreplica coach handbagswhenfendi replica handbagswhenreplica handbagpassengerslouis vuitton replicaheardlinks of london braceletinlinks of london sweetie braceletinlinks of london braceletsdaylinks of london necklacethe Rayban Sunglassester Ray Banhe Rayban Sunglassshe Rayban Sunglass Saletoo Ray Ban Wayfarergo rayban sunglasshaie Buy ray ban sunglasshe Buy Ray banto babyliss irontoo babyliss ceramicday babyliss ceramic ironheard babyliss ceramic hairfro Ghd Limited Editionwas Chi Hair Straightenermembers ceramic hair straightenerflight hair straighteninggo Reply | Quote 0   0

jun  - ewefw     |125.70.56.xxx |2010-01-12 18:43:14 A majority ghd of ghd straighteners people ghd hair straighteners think ghd hair iron that Cheap GHD straighteners staying GHD Hair Products in a straighteners hair place ghd purple for a pink ghd straighteners long Nfl Jerseys time is a Nfl Jersey Sale better cheap nfl jerseys choice.In mens nfl jerseys their charles woodson jersey views authentic nfl jerseys there authentic nfl jerseys cheap are discount nfl jerseys two football nfl jerseys reasons tiffany jewellery contributing tiffany jewelry to tiffany this Cheap Tiffany Jewelry attitude as follows: in the first place,people who stay in one spot can develop a lifetime friendship,and such a friend tiffany 1837 willtiffany and co give a UK tiffany hand Tiffany Necklace without Tiffany Bracelet hesitation Tiffany Earrings if Tiffany rings trouble comes . Reply | Quote 0   0

jun  - ewfew     |125.70.56.xxx |2010-01-12 18:45:29 peopleghd however hair straighteners,differ ghd straighteners in ghd hair straighteners their ghd uk opnions ghd hair styler on Cheap GHD this ghd wide straighteners matterGHD pure .Some pink ghd people GHD Purple hold NFL Jerseys the nfl football jersey idea discount nfl jersey that Authentic Nfl Jersey people NFL Fan Shop shouldn't NFL Apparel live youth nfl jerseys in NFL Store one nfl team apparel place cheap nfl authentic jerseys through lacoste mens clothing their cheap lacoste shirts lives.In lacoste polo shirts their lacoste long sleeve shirt opint lacoste shirts of lacoste Jackets view,on lacoste sweatshirts the lacoste Polos one lacoste Pants hand,people Chanel Sunglasses who Chanel Sunglasses On Sale spend replica chanel sunglasses a discount chanel sunglasses lifetime in one location can be locked into a limited way of life. Reply | Quote 0   0

jun  - wefew     |125.70.56.xxx |2010-01-12 18:46:08 Instant ghd noodles ghds are ghd straighteners great ghd hair straighteners to Cheap GHD eat GHD Purple no GHD MK4 Pink matterNFL Jerseys what NFL football jerseys the Cheap Nfl Jerseys situation nfl replica jersey may nfl replica youth jerseys be. They Nfl Jerseys Sale are nfl custom jerseys easy, extremely pro bowl jerseys quick designer handbags] to ladies designer handbags make designer handbags uk and discount designer handbags require designer handbags sale little louis vuitton handbags knowledge chanel wallet to miu miu handbags make Gucci Wallets them prada Shoulder bag taste Adidas Sport Shoes delicious.Adidas Shoes, the Adidas Mens Running Shoes noodles Adidas Womens Running Shoes must adidas golf shoes be adidas boot placed in a bowl with about five hundred milliliters of boiling water. Reply | Quote 0   0

jun  - ewfew     |125.70.56.xxx |2010-01-12 18:46:37 With ghd the ghd straighteners development ghd purple of ghd purple straighteners the pink ghd Intemet, the ghd staightners pink net bar ghd dark plays nike shoes an Nike Sport Shoes important Nike Running Shoes role Nike Basketball Shoes in Nike Boot people's Cheap Nike Shoes life. More Cheap Nike Air and nike golf shoes more nike children shoes people, especially mbt students, like mbt shoes to discount mbt shoes go mbt sport shoes to mbt womens shoes net mbt shoes cheap bars. They mbt walking shoes are mbt shoes store absorbed weight loss shoes in wigs uk playing wigs for sale video cheap hair extensions games, making wigs hair extensions bad Straight Wig friends Ladies Wigs and Human Hair Wigs having a Long Curly Wig chat Buy Wig with "Meimei" on Short Wigs the wig long net in short red wig the bar. Reply | Quote 0   0

hotuggs  - http://www.hotuggs.net     |59.58.175.xxx |2010-01-14 21:51:24 Drexler said,best ugg boots "Rockets to create their shots, but I could not go to vote." Hayes basket scores, statistics show that inside the rocket and Wolverhampton Wanderers scores were 22 and 14 points. Difficult turnaround jumper to force replica watchesTrevor Ariza, Drexler said, "What is capacity? This is the capability." Battier is also the basket hook scores, Drexler said, "Sean has shown offensive, it's great. "counter-attack in Scola and Trevor Ariza withtop ugg the scores Drexler said," When the Rockets play-transfer complex, their offense would be a lot better. " Reply | Quote 0   0

Boxed Sets   |218.104.230.xxx |2010-01-18 20:25:44 290382728383369175 Funcom, DVD Sets the company DVD Boxed Sets that brought Boxed Set us the violent Boxed Set Dvds and bloody Age DVD Box Sets On Sale of Conan, has Boxed Sets decided to DVD TV Series establish a DVD Box Set subsidiary company under DVD BoxSets the name DVD Box Sets For Sale SweetRobot DVD BoxSet to develop and DVD Box Sets launch a Best DVD Box Sets new MMO Discount DVD Box Sets market casual Dvd Gift Sets market focused Dvd Gift Set on children and DVD Boxed Set adolescents. Reply | Quote 0   0

liping   |125.70.59.xxx |2010-01-22 15:28:42 Some site that arewow gold very helpful are FlipDog.com, Monster.com and Careerwow goldBuilder.com, helpful yes, but costly too. A lot of sites do charge a fee cheap wow goldto post thebuy wow gold job offered or itemsbuy cheap wow gold sold. Fortunately buy wow gold cheapthere are some wow gold cheapgood ones cheapest wow gold everthat do not tbc goldcharge a fee towow gold guide post the listing. wow gold cheapSmarthunt.com gold for wowand Jobertisewow gold prices.com are two wow gold hacksthat are helpful. make wow goldAs a small business wow power levelingor upstart businesswow powerleveling this free service is effectivewow cd key and cost effective. Reply | Quote 0   0

liping   |125.70.59.xxx |2010-01-22 15:29:58 If you are trying to wow levelingget the word out about job positions, products you world of warcraft levelingare selling or a job position indfo gold your company there are manydfo powerleveling ways to godaoc gold about it. Many camelot goldout there rely darkfall goldon olddarkfall power leveling ways to go about cheap ffxi giladvertising their ffxi cheap gilneeds, but thatffxi power leveling mayrunescape gold not alwaysrunescape money be the best rs2 power levelingway to go. maple Story mesosAlthoughMaple Story meso in the pastmaple story power leveling they were EverQuest 2 golda usefuleq2 plat tool, theEQ2 power leveling Internet has city of heroes influencemade them coh influencesort of a thing city of heroes power levelof the past. city of villains infamyThereforeCOV infamy, if you city of villains power levelingare looking metin2 goldto add to metin2 power levelyour companysaion gold payroll or aion power levelingjust looking eve online iskto makeeve isk some extrag... Reply | Quote 0   0

liping   |125.70.59.xxx |2010-01-22 15:31:13 Looking to sell awow cd key product(s)? If selling is world of warcraft cd keyyourwow gold hobby orwow power level businessdfo gold then youcheap dfo gold may want todaoc gold use acamelot gold site that buy darkfallis effective at darkfall goldpromoting your ffxi gilproducts. One cheap ffxi gilthat is veryffxi cd key good is eBay.runescape goldcom. This site is great runescape moneyand offers a lotmaple Story mesos of features, but does Maple Story mesocharge a fee. OneEverQuest 2 gold down side to the fee iseq2 plat that the selleeq2 cd key maycity of heroes influence feel theycoh influence have to city of heroes cd keybumpcity of villains influence up the cov influenceprice of city of villains cd keythe itemmetin2 gold to make metin2 moneyupeve online isk for theeve isk fees aion goldcharged.aion cd key Sogw gold, if guild wars goldlooking guild wars cd keytopc games cd key save a vanguard cd keyfew whilestar wars galaxies cd key posting,lineage2 cd key and age of conan cd keywho warhammer online cd ke... Reply | Quote 0   0

liping   |125.70.59.xxx |2010-01-22 15:32:20 Looking to sell awow cd key product(s)? If selling is world of warcraft cd keyyourwow gold hobby orwow power level businessdfo gold then youcheap dfo gold may want todaoc gold use acamelot gold site that buy darkfallis effective at darkfall goldpromoting your ffxi gilproducts. One cheap ffxi gilthat is veryffxi cd key good is eBay.runescape goldcom. This site is great runescape moneyand offers a lotmaple Story mesos of features, but does Maple Story mesocharge a fee. OneEverQuest 2 gold down side to the fee iseq2 plat that the selleeq2 cd key maycity of heroes influence feel theycoh influence have to city of heroes cd keybumpcity of villains influence up the cov influenceprice of city of villains cd keythe itemmetin2 gold to make metin2 moneyupeve online isk for theeve isk fees aion goldcharged.aion cd key Sogw gold, if guild wars goldlooking guild wars cd keytopc games cd key save a vanguard cd keyfew whilestar wars galaxies cd key posting,lineage2 cd key and age of conan cd keywho warhammer online cd ke... Reply | Quote 0   0

liping   |125.70.59.xxx |2010-01-22 15:33:21 For the theftswow cd key and world of warcraft cd keycorruptionDaoc Gold, adequateCamelot Gold defenseDFO Gold is Dungeon Fighter Goldrequired Darkfall GoldbecauseCheap Darkfall Gold justice is final fantasy xi gilalready at final fantasy 11 cheap gilthe door ffxi gilstep. In a cheap ffxi gilreport filed by a ffxi cheap gilnamed officer from the ffxi cd keyspecialwow gold branch, the Runescape MoneyGovernment has paid a RS2 Goldnumber of people to Maple Story Mesosdestabilize the Maple Story mesoalliance. “the maplestory Mesosproblem the maplestory Mesosystem has is maple mesosthat they don't EverQuest 2 goldknow whoeq2 plat will lead theeverquest 2 cd key pact. Their coh influenceeyes are not city of heroes influenceonly of Mr. city of heroes cd keyHichilema and Mr. COV InfluenceSata, no! theycity of vallains influence are also saying city of villains cd keysuppose this is a repeat of metin2 goldwhat happened metin2 yangbetweenwow buy gold Simon Mwansa guild warsKapwepwe and Hurryguild wars gol... Reply | Quote 0   0

gzm  - nffiwefew   |119.96.26.xxx |2010-01-23 08:41:32 Tibia Gold is the currency in Tibia(MMoRPG) .There are many items including Tibia weapons like  Tibia Axe,Tibia Sword,Tibia Rod,Tibia Wand,Tibia Shield And also Tibia euipment Tibia helmet,Tibia armor,Tibia legs, Tibia boots These items let you always prevailed(Not only play a important role in the war, but also pawn the monster smoothly and level up easier) You can buy all these items by using Tibia gold And there still many sites u can buy tibia gold by real money like tibiaitem.com,tibiamoney.com,gamegoldcoin.com,game zmoney.com,10m inget.com,enjoygolds.com, tibiagood s.com gameotl.com etc Good luck, have fun in Tibia tibia gold tibia money tibia item tibia items buy tibia gold tibia weapon tibia leveling armor tibia tibia level tibia account tibia gold tibia money tibia item tibia items buy tibia gold tibia weapon tibia leveling armor tibia Reply | Quote 0   0

gzm  - kjbk   |119.96.26.xxx |2010-01-23 08:41:50 Final Fantasy XIV is a Online Role Playing Game for the PS3. Final Fantasy XIV takes the first intrepid steps into an unknown realm, and in doing so a new place for adventurers of all creeds to call home is born - Erozea ffxiv gil ffxiv money ffxiv gold ffxiv gil ffxiv money ffxiv gold final fantasy XIV gil buy ffxiv gil final fantasy XIV money ffxiv money ffxiv gold final fantasy XIV money buy ffxiv gil final fantasy XIV gil ffxiv gil ffxiv money ffxiv gold final fantasy XIV money buy ffxiv gil final fantasy XIV gil ffxiv gil ffxiv money ffxiv gold final fantasy XIV money buy ffxiv gil final fantasy XIV gil ffxiv gil ffxiv money ffxiv gold final fantasy XIV gil buy ffxiv gil final fantasy XIV money runescape gp runescape item runescape gold runescape money buy runescape runescape account runescape quest runescape gp runescape item runescape gold runescape money buy runescape runescape account runesc... Reply | Quote 0   0

gzm  - yufhjbnm   |119.96.26.xxx |2010-01-23 08:42:12 Guild Wars is an episodic series of multiplayer online role-playing games developed by ArenaNet and published by NCsoft. Although often defined as an MMORPG, the developers define it as a CORPG due to notable differences from the MMORPG genre guild wars armor guild wars platinum guild wars farming guild wars buy guild wars shop gw gold guild wars gold guild wars money guild wars armor guild wars platinum guild wars farming guild wars buy guild wars shop gw gold guild wars gold guild wars money guild wars armor guild wars platinum guild wars farming guild wars buy guild wars shop gw gold guild wars gold guild wars money guild wars armor guild wars platinum guild wars farming guild wars buy guild wars shop gw gold guild wars gold guild wars money guild wars armor guild wars platinum guild wars farming guild wars buy guild wars shop gw gold guild wars gold guild wars money guild wars armor guild wars platinum guild wars farmin... Reply | Quote 0   0

ugg boots home  - http://www.uggbootshome.net     |59.58.175.xxx |2010-01-25 23:36:50 Ugg This is a legendary general term for boots the first thing you see her in person will be heavy but the shape of this Qichou not understood, ugg bootsbut is such a rage in Europe and Asia boots, earth, and is now in the world have whipped up a popular style, basketball shoes this is a gust of mainstream stars in Europe and America brought the. Reply | Quote 0   0

cpp   |219.140.238.xxx |2010-02-20 08:51:46 armor tibia, tibia level, tibia account, tibia gold, tibia money, tibia item, tibia level, tibia account, runescape gp, runescape quest, buy runescape, runescape money, runescape item, runescape account, runescape gold, http://www.afghanistanwatch.org/2007/07/t om-perriello-c.html#comment-captcha guild wars farming,guild wars gold, gw gold, guild wars money, guild wars platinum, guild wars platinum, guild wars farming, guild wars gold, gw gold, guild wars money, gw gold, Reply | Quote 0   0

cpp   |219.140.238.xxx |2010-02-20 08:52:25 guild wars shop gw gold guild wars gold guild wars money Reply | Quote 0   0

Write comment
Name:
Email:	do not notifynotify
Website:
Title:
UBBCode:	-color-aquablackbluefuchsiagraygreenlimemaroonnavyolivepurpleredsilvertealwhiteyellow -size-tinysmallmediumlargehuge
	Please input the anti-spam code that you can read in the image.

Powered by !JoomlaComment 3.26

3.26 Copyright (C) 2008 Compojoom.com / Copyright (C) 2007 Alain Georgette / Copyright (C) 2006 Frantisek Hliva. All rights reserved."