 |
|
茫茫網海中的冷日
發生過的事，不可能遺忘，只是想不起來而已！ |
|
|
恭喜您是本站第 1671295
位訪客!
登入 | 註冊
|
|
|
|
| 發表者 |
討論內容 |
冷日
(冷日) |
發表時間：2019/3/22 11:36 |
- Webmaster
- 註冊日: 2008/2/19
- 來自:
- 發表數: 15771
|
- [轉貼]how to unlock user
- how to unlock user
I installed Oracle 11g R2 sucessfully. But not able to login as i found message user locked , kindly guide me how to unlock user.
1. Re: how to unlock user
Pobaly your user needs create session priviledge.
Log in as a SYSTEM and performs the grant below.
grant create session to USER;
Regards,
Raul.
2. Re: how to unlock user
To unlock a user Run the following sql as administrator user like SYS or SYSTEM
ALTER USER user_name IDENTIFIED BY password ACCOUNT UNLOCK;
here password is your passord which you want to use for your account remember this password for further use.
Hope this will help you
原文出處：how to unlock user | Oracle Community
|
|
|
冷日
(冷日) |
發表時間：2019/3/22 11:38 |
- Webmaster
- 註冊日: 2008/2/19
- 來自:
- 發表數: 15771
|
- [轉貼]How to unlock Oracle user account?
- How to unlock Oracle user account?
Here's how to lock or unlock Oracle database user accounts.
SQL> ALTER USER username ACCOUNT LOCK;
SQL> ALTER USER username ACCOUNT UNLOCK;
iguissouma commented on 26 Nov 2015
To unlock a user Run the following sql as administrator user like SYS or SYSTEM
ALTER USER user_name IDENTIFIED BY password ACCOUNT UNLOCK;
here password is your passord which you want to use for your account remember this password for further use.
mohamad7788 commented on 12 Oct 2018 •
Thanks for sharing such command .
in this form , i would like to share a command to create Oracle account & change password
create account :
CREATE USER <account-name>IDENTIFIED BY <account-password> password expire DEFAULT TABLESPACE <table-space name> TEMPORARY TABLESPACE TEMP QUOTA UNLIMITED ON <table-space name> PROFILE PERSONAL;
change account password :
alter user <account-name> identified by "<accountpassword>"
原文出處：How to unlock Oracle user account? · GitHub
|
|
|
|
|
冷日
(冷日) |
發表時間：2019/3/22 11:55 |
- Webmaster
- 註冊日: 2008/2/19
- 來自:
- 發表數: 15771
|
- [轉貼]How to Unlock the Account in Oracle
Steps 1 Find which accounts are locked with the following query. - SQL > select username,account_status from dba_users where account_status like '%LOCK%';
- USERNAME ACCOUNT_STATUS
- ------------------------------ ----------------
- OUTLN EXPIRED & LOCKED
- MDSYS EXPIRED & LOCKED
- MDDATA EXPIRED & LOCKED
2 Unlock the user with the following command. - SQL > alter user MDDATA account unlock; User altered.
原文出處：How to Unlock the Account in Oracle: 2 Steps (with Pictures)
|
|
|
冷日
(冷日) |
發表時間：2019/3/22 11:57 |
- Webmaster
- 註冊日: 2008/2/19
- 來自:
- 發表數: 15771
|
- [轉貼]How to retrieve oracle passwords
- How to retrieve oracle passwords
Oracle Database Tips by Donald Burleson
Question:
I need to sign-on as an end-user for troubleshooting, but they don't want their password changed. Can I save their existing password, do my work, and put back their old password?
Answer:
You can retrieve an existing password as an encrypted value and you can also copy encrypted passwords between databases.
The dbms_metadata procedure allows you to copy user accounts from one instance to another with the same password, grants, roles, etc, without using the exp/imp tools.
You wont be able to see the password (sorry hackers), but you can copy it in its encoded form. This is extremely useful for DBAs that are copying their production database to development, or migrating a database from one instance to another.
Here we use the DBMS_METADATA package to pull the user password information. Once the encrypted password is captured, it can be re-inserted into the user ID after you are done testing:
select
dbms_metadata.get_ddl('USER', username) || '/' usercreate
from
dba_users;
USERCREATE
--------------------------------------------------------------
CREATE USER "SYS" IDENTIFIED BY VALUES 'F894844C34402B67'
DEFAULT TABLESPACE "SYSTEM" TEMPORARY TABLESPACE "TEMP"/
原文出處：How to retrieve oracle passwords
|
|
|
|
