Change Oracle Database User Password Baguhin ang Oracle database User Password
To ensure security of the Oracle database system and prevent unauthorized access to the Oracle database, it’s important for Oracle users to not only using strong and long Oracle passwords to avoid brute force or dictionary attacks, but also to change the Oracle user password regularly. Upang masiguro ang seguridad ng Oracle database system at maiwasan ang hindi awtorisadong pag-access sa Oracle database, ito ay mahalaga para sa Oracle users na hindi lamang ang paggamit ng malakas at mahaba Oracle password upang maiwasan ang malupit na puwersa o diksiyunaryo atake, ngunit rin na baguhin ang Oracle user password regular na . Oracle users also have to change the password when the password has or going to expire, if database system administrator implements and enforces strict password control with PASSWORD_LIFE_TIME option for user profiles which limits the number of days the password can be used for authentication to login to the system. Oracle users ay mayroon din na baguhin ang password kapag ang mga password ay mawawalan ng bisa o pagpunta sa, kung database system administrator nagpapatupad at enforces mahigpit password kontrol sa PASSWORD_LIFE_TIME pagpipilian para sa user na profile na limitasyon sa bilang ng mga araw na ang mga password ay maaaring gamitin para sa authentication sa pag-login sa sistema.
To change the Oracle password, users can use SQL*Plus or Oracle SQL and PL/SQL language interface administration tool such as Toad for Oracle. Upang baguhin ang password sa Oracle, ang mga user ay maaaring gumamit ng SQL * Plus o Oracle at SQL PL / SQL wika ng interface ng administrasyon na kasangkapan tulad ng palaka para sa Oracle. No matter what SQL apps you use, the commands and SQL query languages used to change the password are similar. Kahit na ano SQL apps na gamitin mo, ang command at SQL query na wika na ginagamit upang palitan ang password ay katulad.
There are two SQL command syntaxes that can be used to change Oracle database user password: Mayroong dalawang SQL command syntaxes na maaaring magamit upang baguhin Oracle database ng user password:
ALTER USER user_name IDENTIFIED BY new_password ; Baguhin USER USER_NAME nakilala BY new_password;
or (from Oracle8 and above): o (mula sa Oracle8 at sa itaas):
PASSWORD
For above SQL query, if you need to change another user’s password, use the following command: Sa itaas para sa mga SQL query, kung kailangan mong palitan ng isa pang user ng password, gamitin ang sumusunod na command:
PASSWORD user_name PASSWORD USER_NAME
For PASSWORD command, after you press Enter, you will be prompted to input the old password and new password interactively. Para sa mga PASSWORD command, pagkatapos mong pindutin ang Enter, ikaw ay sesenyasan na input ang lumang password at bagong password interactively. For example: Halimbawa:
SQL> password SQL> password
Changing password for DAVID Ang pagpapalit ng password para sa DAVID
Old password: Lumang password:
New password: Bagong password:
Retype new password: Retype bagong password:
Note: You need to have enough privileges to change other Oracle user’s password. Tandaan: Kailangan mong magkaroon ng sapat na mga pribilehiyo na baguhin ang ibang Oracle user's password.
As the variable in italic implied by name, user_name is the user whose password wishes to be changed, and new_password is the new password to assign. Bilang ng variable sa italic ipinahiwatig sa pamamagitan ng pangalan, USER_NAME ay ang mga user na may password na hangarin na maging ay nagbago, at new_password ay ang bagong password sa italaga.
As ALTER USER SQL syntax will send the new password to the Oracle database server unencrypted if use without Advanced Security Option, and thus expose to security risk, Oracle users should always use the PASSWORD command to change the Oracle user password. Bilang baguhin USER SQL syntax ay ipadala ang bagong password sa Oracle database server unencrypted kung gamitin nang walang Advanced Security Option, at kaya itaya sa panganib sa seguridad, Oracle users ay dapat palaging gumamit ng PASSWORD command upang baguhin ang Oracle user password.
IMPORTANT : This is a machine translated page which is provided "as is" without warranty. MAHALAGA: Ito ay isang makina isinalin pahina na kung saan ay ibinigay "bilang ganito" walang warranty. Machine translation may be difficult to understand. Makina ng pagsasalin ay maaaring mahirap maintindihan. Please refer to Mangyaring sumangguni sa original English article orihinal na Ingles article whenever possible. hangga't maaari.
Share and contribute or get technical support and help at Share at kontribusyon o makakuha ng teknikal na suporta at tulong sa My Digital Life Forums Aking Digital buhay Forums .
Related Articles Mga Kaugnay na Akda
- Oracle Database Link Oracle database link
- Oracle EXP-00091 Error When Export Database Oracle EXP-00091 error kapag i-export ang database ng
- Oracle Database Import Error 3113/3114 Oracle Database Error sa pag-import 3113/3114
- View and Retrieve Oracle Database Link Details Tingnan at kunin Oracle database Link Details
- How to Remove and Drop Datafiles from Tablespace in Oracle Database Kung paano Alisin at Drop Datafiles mula sa sa tablespace Oracle Database
- Apple iPhone Root Password and Mobile User Password Investment Root password at user Mobile password
- Create, Add or Split Oracle Database Partition Fails with ORA-14080 Error Lumikha ng, o Magdagdag ng Split Oracle Database Partisyon Nabigo sa ORA-14080 Error
- How Drop Tablespace and Recover Oracle Database When Accidentally Delete Datafile Paano drop tablespace at makuha Oracle database kapag sinasadyang tanggalin ang Datafile
- IMP-00016 Required Character Set Conversion Not Supported Error when Import to Oracle Database Malikot na bata-00016 kinakailangan character set ng conversion na hindi suportado ng error kapag nag-i-import sa Oracle database
- How to Customize, Modify or Change WordPress Database Connection Error Page Kung paano mag-customize, baguhin o palitan WordPress database Connection Error Page
