Skip to Main Content
  • Questions
  • Find the roles that are currently granted to current users who have not logged in for more than 180 days

Breadcrumb

May 4th

Question and Answer

Chris Saxon

Thanks for the question, Cornellius.

Asked: January 27, 2017 - 2:12 pm UTC

Last updated: January 27, 2017 - 5:00 pm UTC

Version: Oracle 11g

Viewed 1000+ times

You Asked

How do I find the roles that are currently granted to current users who have not logged in for more than 180 days? I want to revoke their user roles. Thanks.

and Chris said...

You can find the roles using the *_role_privs views:

select * from dba_role_privs
where  grantee in (select username from ...);


Where "select username from ..." is the query you chose from the answer to: https://asktom.oracle.com/pls/apex/f?p=100:11:::NO:RP:P11_QUESTION_ID:9532975900346248302

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Thank you. Thank you. Thank you.

Cornellius Amey, January 27, 2017 - 4:10 pm UTC

Thank you very much for your answer. I am teaching myself Oracle and you have been helpful.
Chris Saxon
January 27, 2017 - 5:00 pm UTC

Happy to help! :)