Forum Stats

  • 3,826,356 Users
  • 2,260,635 Discussions
  • 7,896,916 Comments

Discussions

Is there a way to use spreadsheet to mass deactivate & lock user accounts?

User_57PBZ
User_57PBZ Member Posts: 1 Red Ribbon

Hi!

Does anyone know if there is a way to mass deactivate & lock user accounts?

We have over 1000 users that are no longer working in the company but still show up in User Role Membership Report and I would like to clean this up. I'm hoping I can use HDL or spreadsheet import functionality to deactivate them rather than going through the UI to deactivate each one.

What I have is the username, but no first/last name from the User Role Membership Report (first & last names are shown as "NO DATA AVAILABLE").

Any insight/help would be appreciated! Thanks.

Petricia

Answers

  • PaulWhite
    PaulWhite Member Posts: 1 Green Ribbon

    Hi Petricia,

    Surely many companies find users that need to be inactivated when running the Inactive Users Report but Oracle doesn't suggest such a program to assist companies which is a miss.

    Did you ever find a solution?

    Thanks,

    Paul