| 标题 | oracle修改用户登录密码 |
| 内容 | 1、使用oracle用户登录，连接数据库 [oracle@wuzj ~]$ sqlplus /nolog SQL*Plus: Release 10.2.0.1.0 - Production on Thu Feb 26 12:06:29 2009 Copyright (c) 1982, 2005, Oracle. All rights reserved. SQL> conn /as sysdba Connected. //查看用户 SQL> select username,password from dba_users; USERNAME PASSWORD ------------------------------ ------------------------------ USER1 BBE7786A584F9103 MGMT_VIEW 4F538DF5F344F348 SYS 8A8F025737A9097A SYSTEM 970BAA5B81930A40 DBSNMP FFF45BB2C0C327EC SYSMAN 2CA614501F09FCCC OUTLN 4A3BA55E08595C81 MDSYS 72979A94BAD2AF80 ORDSYS 7EFA02EC7EA6B86F EXFSYS 66F4EF5650C20355 DMSYS BFBA5A553FD9E28A USERNAME PASSWORD ------------------------------ ------------------------------ WMSYS 7C9BA362F8314299 CTXSYS 71E687F036AD56E5 ANONYMOUS anonymous XDB 88D8364765FCE6AF ORDPLUGINS 88A2B2C183431F00 SI_INFORMTN_SCHEMA 84B8CBCA4D477FA3 OLAPSYS 3FB8EF9DB538647C SCOTT F894844C34402B67 TSMSYS 3DF26A8B17D0F29F BI FA1D2B85B70213F3 PM 72E382A52E89575A USERNAME PASSWORD ------------------------------ ------------------------------ MDDATA DF02A496267DEE66 IX 2BE6F80744E08FEB SH 9793B3777CD3BD1A DIP CE4A36B8E06CA59C OE 9C30855E7E0CB02D HR 6399F3B38EDF3288 28 rows selected. //修改用户口令 格式 alter user 用户名 identified by 新密码; SQL> alter user system identified by manager; User altered. //再次查看，对比发现密码已经更换 SQL> select username,password from dba_users; USERNAME PASSWORD ------------------------------ ------------------------------ USER1 BBE7786A584F9103 MGMT_VIEW 4F538DF5F344F348 SYS 8A8F025737A9097A SYSTEM D4DF7931AB130E37 DBSNMP FFF45BB2C0C327EC SYSMAN 2CA614501F09FCCC OUTLN 4A3BA55E08595C81 MDSYS 72979A94BAD2AF80 ORDSYS 7EFA02EC7EA6B86F EXFSYS 66F4EF5650C20355 DMSYS BFBA5A553FD9E28A USERNAME PASSWORD ------------------------------ ------------------------------ WMSYS 7C9BA362F8314299 CTXSYS 71E687F036AD56E5 ANONYMOUS anonymous XDB 88D8364765FCE6AF ORDPLUGINS 88A2B2C183431F00 SI_INFORMTN_SCHEMA 84B8CBCA4D477FA3 OLAPSYS 3FB8EF9DB538647C SCOTT F894844C34402B67 TSMSYS 3DF26A8B17D0F29F BI FA1D2B85B70213F3 PM 72E382A52E89575A USERNAME PASSWORD ------------------------------ ------------------------------ MDDATA DF02A496267DEE66 IX 2BE6F80744E08FEB SH 9793B3777CD3BD1A DIP CE4A36B8E06CA59C OE 9C30855E7E0CB02D HR 6399F3B38EDF3288 28 rows selected. SQL> //现在就可以用此密码链接进行操作了 SQL> connect system/manager 已连接。 ========================== 另一种修改值的办法 SQL> alter user system identified by values '2D594E86F93B17A1'; 用户已更改。 //在试试这个密码 SQL> connect system/oracle 已连接。 //这个密码就不灵了 SQL> connect system/manager ERROR: ORA-01017: invalid username/password; logon denied |
| 随便看 |
|
在线学习网考试资料包含高考、自考、专升本考试、人事考试、公务员考试、大学生村官考试、特岗教师招聘考试、事业单位招聘考试、企业人才招聘、银行招聘、教师招聘、农村信用社招聘、各类资格证书考试等各类考试资料。