WHO IS LOCKING MY ORACLE ACCOUNT?
Why an Oracle user is locked? Who is locking an Oracle user?
HOW TO RESET AN ORACLE ACCOUNT PASSWORD
How can I change a password for a user in Oracle? How to set the same password to the expired user account without knowing the original password?
HOW TO FIND ALL OBJECTS PRIVILEGES GRANTED TO A USER IN AN ORACLE DATABASE
Here is a query to a data dictionary table for finding out all the object privileges that a particular user or a role has. It also displays if a privilege is transferred directly or through a role.
HOW TO FIND SYSTEM, ROLES AND OBJECTS PRIVILEGES THAT HAVE BEEN GRANTED TO A USER
How to find the privileges that have been granted to a user by querying data dictionary views.
HOW TO RETRIEVE AN OBJECT DDL OR A USER DDL USING PL/SQL
How to extract metadata of users, tables, views, triggers, and other Oracle database objects by using the metadata API.