Alter an user - oracle database script

-- Change password of an user  ALTER USER SCOTT identified by NEW_PWD;   -- Change user profile;  ALTER USER SCOTT PROFILE SIEBEL_PROFILE;  -- Unlock/lock a user  ALTER USER SCOTT account unlock; ALTER USER SCOTT account lock;  -- Make sure account expiry, so upon login, it will ask for new one  ALTER USER SCOTT password expire;