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