Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

howt to find inactive users to drop

Hans MüllerDec 15 2023 — edited Dec 15 2023

How can I find out inactive (inactive for more than 1 year) database users and delete them? A backup of the scheme should be made beforehand. How would you do that?

what else do you have to pay attention to? Profiles? Permissions?

it's about oracle DB and query in sql

Comments
Post Details
Added on Dec 15 2023
7 comments
525 views