Shulou(Shulou.com)05/31 Report--

This article mainly shows you "how to temporarily change the passwords of other unknown users in ORACLE". The content is simple and clear. I hope it can help you solve your doubts. Let me lead you to study and learn this article "how to temporarily modify the passwords of other unknown users in sys in ORACLE".

ORACLE uses different password policies in pre-11g,11g, 12c, so apply corresponding version modifications.

Modification methods for previous versions of 11g

It is convenient to use the alter user identified by values command

[oracle@orazhang] $oraSQL*Plus: Release 10.2.0.1.0-Production on Thursday September 22 10:42:07 2011Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-ProductionWith the Partitioning, OLAP and Data Mining options-- anbob password is anbobsys@ORCL > select NAME,PASSWORD from user$ where name='ANBOB' NAME PASSWORD-- ANBOB ACF67A552551E848sys@ORCL > alter user anbob identified by anbob123;User altered.sys@ORCL > select NAME,PASSWORD from user$ where name='ANBOB' NAME PASSWORD-- ANBOB 64096627C6DB8EEAsys@ORCL > conn anbob/anbob123Connected.anbob@ORCL > select'do something' from dual 'DOSOMETHING-do somethinganbob@ORCL > conn / as sysdbaConnected.anbob@ORCL > alter user anbob identified by values' ACF67A552551E848';sys@ORCL > conn anbob/anbobConnected.

The modification method of 11g version

The sec_case_sensitive_logon parameter controls whether the password is case sensitive.

The # 11g version DBA_USERS view adds a column of PASSWORD_VERSIONS to record which hash algorithm the current password uses. If 11G, the new hash value will be recorded in the user$.spare4 field. If you check the previous dba_user.password, it will be NULL.

1SQL > select spare4 from user$ where name='ANBOB';--remeber the values2, SQL > alter user anbob identified by [newvalue] 3, SQL > alter user anbob identified by values [# 1 spare4 value]

# record all current user passwords

Select 'alter user' | | name | | 'identified by values''| | password |''; 'from user$ where spare4 is null and password is not nullunionselect' alter user'| | name | | 'identified by values''| | spare4 |;'| | password | |'';'it seems that a new HASH algorithm has been added to the from user$ where spare4 is not null and password is not null;12c# version. The above is all the contents of the article "how to temporarily change the passwords of other unknown users in sys in ORACLE". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.