把soctt的密码给忘记了 怎么修改啊 各位高人? sys和system的密码知道
解决方案 »
- oracle 审计 fga 如何与 session 关联?
- A表的ST_GEOMETRY类型插入到B表的ST_GEOMETRY类型,怎么做?
- OracleParameter 参数问题
- 请教达人,批量数据insert的自动提交问题
- 菜烏鍵表問題,哥們幫幫
- 如何使用Oracle发送带有附件的邮件??
- 初学者关于存储过程(创建表)的简单问题(在线等待)
- 求助:关于Oracle9i中的全文索引的问题!!!来者有分!!!谢了先!!!
- oracle9i的卸载问题
- 关于PK和INDEX讨论,参与讨论给分,截止8.8
- ORACLE数据块中的SCN是如何变化的?
- raise_application_error抛出异常时文字过多的问题
--dba身份登录
alter user user_name identified by new_pswd;
--
Connected as SYS
SQL> create user paul identified by hao123;
User created
SQL> grant resource,connect to paul;
Grant succeeded
SQL> commit;
Commit complete
SQL> conn paul/hao123;
Connected to Oracle Database 10g Enterprise Edition Release 10.1.0.2.0
Connected as paul
SQL> create table t(col_1 number,col_2 date);
Table created
SQL> conn system/manager as sysdba;
Connected to Oracle Database 10g Enterprise Edition Release 10.1.0.2.0
Connected as SYS
SQL> alter user paul identified by nihao123;--修改密码
User alteredSQL> conn paul/hao123;---使用原来密码
ERROR:
ORA-01017: invalid username/password; logon deniedWarning: You are no longer connected to ORACLE.
SQL> conn paul/nihao123;--使用修改后的新密码
Connected.
SQL>
cmd回车
sqlplus sys as sysdba 回车,回车
alter user scott account unlock; 回车
alter user scott identified by tiger; 回车
disc; 回车
exit 回车
exit 回车
sys as sysdbasql>alter user scott identified by 新密碼
passw scott
后面有提是
alt左边的键盘+r
cmd回车
sqlplus sys as sysdba 回车,回车
alter user scott account unlock; 回车
alter user scott identified by tiger; 回车
disc; 回车
exit 回车
exit 回车
实验可以得到正确结果。
Connected.
SQL> alter user scott identified by tiger;
User altered.
SQL> conn scott/tiger;
Connected.
这个指令的好处在于不需要知道原密码就可以改你的密码。看,DBA多牛逼、