DBA Hub

📋Steps in this guide1/1

Alter an user

-- Change password of an user

oracle configurationintermediate
by OracleDba
13 views
1

Alter an user

-- Change password of an user -- Change user profile; -- Unlock/lock a user -- Make sure account expiry, so upon login, it will ask for new one

Code/Command (click line numbers to comment):

1
2
3
4
5
ALTER USER SCOTT identified by NEW_PWD;
ALTER USER SCOTT PROFILE SIEBEL_PROFILE;
ALTER USER SCOTT account unlock;
ALTER USER SCOTT account lock;
ALTER USER SCOTT password expire;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!