title: Select User Accounts Not Logged In Database for 180 Days to Revoke Roles
body: <p>How do I write a SELECT statement that "show all user accounts" that have not logged into the database for more than 180 days? My goal is to revoke the users accounts roles that have not logged into the database for more the 180 days.</p>
  
  <p>In other words, I need to find the roles that are currently granted to current users who have not logged in for more than 180 days.</p>
  
  <p>I am using Oracle 11g.</p>
  
  <p>Thank you.</p>