Unlock oracle users and permission settings

AlterUserHR account unlock;AlterUserHR identifiedByAdmin; -- Change Password
 

 
GrantSelectAnyTableToUser1 ;--
 

-- Use a user in Oracle to access tables of other users -- use HR to log on to the user with the permissions granted to the user. Grant  Create   Session , Create   Any   Table ,Create   Any   View , Create   Any   Index , Create   Any   Procedure , Alter   Any   Table , Alter   Any   Procedure , Drop   Any   Table , Drop  Any   View , Drop   Any   Index , Drop   Any   Procedure , Select   Any   Table , Insert Any   Table , Update   Any   Table , Delete   Any   Table  To Scott; then use Scott to log on, Select * From HR. Employees -- View roles owned by users or roles Select * From User_role_privs; -- this user can grant this system permission to another user or role Grant   Connect   To Scott With   Admin   Option ; Grant Resource To Scott With   Admin   Option For example, if you authorize system a create Session   With   Admin   Option Then a grants the create session permission to B, but when the Administrator revokes the create session permission of a, B still has the create session permission, but the administrator can explicitly revoke B Create Session permission, that is, direct revoke Create   Session   From B.