How to Unlock/Change Password For Oracle User?

Unknown 3:56 PM ORACLE No comments

When you want to lock/unlock an oracle user, my suggestion is to user the sql command “alter user” like:

SQL> ALTER USER username ACCOUNT LOCK;
SQL> ALTER USER username ACCOUNT UNLOCK;

In case you need to change the password of an oracle user the recomandation from SAP is to change the password with brconnect. The right command is:

brconnect [-u system/<system_password>] –c –f chpass –u <user_name> –p <new_password>

Where:

<system_password> is the password of the SYSTEM database user. You can use another user with DBA privileges.
<user_name> is the database user for which the password should be changed (for example, SAP<SAPSID>).
<new_password> is the new password for the user.

No comments :

Post a Comment

Subscribe to: Post Comments ( Atom )