分享Oracle密码忘记找回的办法

相信大多数人会遇到这样的问题,我也遇到了这样的问题,废话不多说。

首先他会让你输入用户名:你只要输入connect/as sysdba,注意as 和sysdba之间有空格 。然后他会叫你输入 
口令。但是不要理他,点击enter。OK 链接成功了。接下来你就要 


1 创建用户/密码并授权  


Oracle创建用户/密码并授权 


(1)       创建用户 


Create user 用户名 identified by 密码;(如果是数字则要加双引号”111111”,如果是字母就不用) 


(2)       授权给某个用户 


Grant connect,resource to 用户名;(只有用户有了connect 和 resource后才能操作其他表) 


(3)       授DBA 权限 


Grant dba to 用户名; 


(4)       给用户创建会话的权限: 


grant create session to DB_USER     


(3)       授DBA 权限 


Grant dba to 用户名; 


(4) 撤权:    
       revoke   权限...   from 用户名; 


(5)删除用户: 
2  修改用户名和密码 
   修改用户密码(例:修改sys用户密码为123):alter user sys identified by 123; 


1、windows 平台下运行 cmd 


2、sqlplus /nolog 


3、SQL> connsys/lmis@lmisdx_localas sysdba 连接到数据库。通常可以用sys用户登陆。 


4、SQL> select * from user$; 找到 name为需要修改的用户的user#。 


5、SQL> UPDATE USER$ SET NAME=‘新用户名‘ WHERE USER#=38; 
   已更新 1 行。 


6、SQL> COMMIT;提交完成。 


7、SQL> ALTER SYSTEM CHECKPOINT; 
   系统已更改。 


8、SQL> ALTER USER 新用户名 IDENTIFIED BY 新密码; 
   此时会提示新用户不存在。 


SQL> ALTER USER 新用户名 IDENTIFIED BY 新密码         


*ERROR 位于第 1 行:ORA-01918: 用户‘新用户‘不存在 


SQL> ALTER USER 新用户名 IDENTIFIED BY 新密码         


*ERROR 位于第 1 行:ORA-01918: 用户‘新用户‘不存在 
9、SQL> ALTER SYSTEM FLUSH SHARED_POOL; 
   系统已更改。 


10、SQL> ALTER USER 新用户 IDENTIFIED BY 新密码; 

    用户已更改。 

http://www.wenjuan.com/s/e63UFfz
http://www.wenjuan.com/s/fIfuYf
http://www.wenjuan.com/s/uuuI7b
http://www.wenjuan.com/s/NzMbYz
http://www.wenjuan.com/s/222EB3
http://www.wenjuan.com/s/7V3uqic
http://www.wenjuan.com/s/6rIz6z
http://www.wenjuan.com/s/Bzuq2e
http://www.wenjuan.com/s/bQFjQ3
http://www.wenjuan.com/s/bQFjQ3
http://www.wenjuan.com/s/MfM32u
http://www.wenjuan.com/s/zyYVZnB
http://www.wenjuan.com/s/R3Yfme
http://www.wenjuan.com/s/a2iQfy
http://www.wenjuan.com/s/MrEnIr
http://www.wenjuan.com/s/FZ7ZFf
http://www.wenjuan.com/s/m2IJze
http://www.wenjuan.com/s/7JzM73
http://www.wenjuan.com/s/UbQrEv
http://www.wenjuan.com/s/FrU3Eb
http://www.wenjuan.com/s/qAreIb
http://www.wenjuan.com/s/2aEnme
http://www.wenjuan.com/s/7jEV3e
http://www.wenjuan.com/s/QFNRvq
http://www.wenjuan.com/s/JrMBnq
http://www.wenjuan.com/s/6zMJRb
http://www.wenjuan.com/s/MBne6fn
http://www.wenjuan.com/s/22EBZz
http://www.wenjuan.com/s/7FfAVb
http://www.wenjuan.com/s/YJruyy
http://www.wenjuan.com/s/zAz67r
http://www.wenjuan.com/s/QjIRbu
http://www.wenjuan.com/s/BveMRv
http://www.wenjuan.com/s/7n2Ife
http://www.wenjuan.com/s/N3qeua
http://www.wenjuan.com/s/eiEbEj
http://www.wenjuan.com/s/zqMVva9
http://www.wenjuan.com/s/6n6va22
http://www.wenjuan.com/s/v6B7Vv
http://www.wenjuan.com/s/zmMJBn
http://www.wenjuan.com/s/YNNNri
http://www.wenjuan.com/s/buqueq
http://www.wenjuan.com/s/Af6NF3
http://www.wenjuan.com/s/QVJZNv
http://www.wenjuan.com/s/eIbUJz
http://www.wenjuan.com/s/mQzUVv
http://www.wenjuan.com/s/yyYzuq
http://www.wenjuan.com/s/AFnANv
http://www.wenjuan.com/s/6Bvaqq
http://www.wenjuan.com/s/7rANb2
http://www.wenjuan.com/s/my6BVz
http://www.wenjuan.com/s/biIVnu
http://www.wenjuan.com/s/q6VR7b
http://www.wenjuan.com/s/2UZJr21
http://www.wenjuan.com/s/nIVr2e
http://www.wenjuan.com/s/b2UFbu
http://www.wenjuan.com/s/YJjeym
http://www.wenjuan.com/s/uamm2e
http://www.wenjuan.com/s/yaeER3
http://www.wenjuan.com/s/aaueuq
http://www.wenjuan.com/s/e6fIZv
http://www.wenjuan.com/s/AZ36ze
http://www.wenjuan.com/s/3aYfQn
http://www.wenjuan.com/s/i6zeym
http://www.wenjuan.com/s/IfuANb
http://www.wenjuan.com/s/Un6Jre
http://www.wenjuan.com/s/vMVNJb
http://www.wenjuan.com/s/MBBBfe
http://www.wenjuan.com/s/7fQJJn
http://www.wenjuan.com/s/vQzMFv
http://www.wenjuan.com/s/uUBNba
http://www.wenjuan.com/s/bqaEzu
http://www.wenjuan.com/s/VBva2y
http://www.wenjuan.com/s/mE7bQv
http://www.wenjuan.com/s/jIzaeq
http://www.wenjuan.com/s/yyqQNj
http://www.wenjuan.com/s/V32yyu
http://www.wenjuan.com/s/V32yyu
http://www.wenjuan.com/s/iI7nQ3
http://www.wenjuan.com/s/YFbqMb
http://www.wenjuan.com/s/UfA3qqV
http://www.wenjuan.com/s/j2IN7b
http://www.wenjuan.com/s/RF7fIr
http://www.wenjuan.com/s/BJzA7f
http://www.wenjuan.com/s/FNj6Fz
http://www.wenjuan.com/s/YrQFJb
http://www.wenjuan.com/s/BFbequ
http://www.wenjuan.com/s/iayARj
http://www.wenjuan.com/s/EbaqYj
http://www.wenjuan.com/s/Jf2uAv
http://www.wenjuan.com/s/Jf2uAv
http://www.wenjuan.com/s/aiU7fe
http://www.wenjuan.com/s/AzEb2y
http://www.wenjuan.com/s/AzEb2y
http://www.wenjuan.com/s/eUR3q2
http://www.wenjuan.com/s/6rIzAr
http://www.wenjuan.com/s/YFfINv
http://www.wenjuan.com/s/vU7FBv
http://www.wenjuan.com/s/vAvMzqt
http://www.wenjuan.com/s/r2Ariy
http://www.wenjuan.com/s/RFfmEr
http://www.wenjuan.com/s/RFfmEr
http://www.wenjuan.com/s/2aiY7b
http://www.wenjuan.com/s/zYJ3e2
http://www.wenjuan.com/s/2I3Yji
http://www.wenjuan.com/s/BRBNvu
http://www.wenjuan.com/s/JFBZzm
http://www.wenjuan.com/s/qYn2yi
http://www.wenjuan.com/s/22ANZv
http://www.wenjuan.com/s/MrIB7n

郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。