Skip to main content
dvillarreal
dvillarreal
Gold ⭐️
April 14, 2017

Delete users and groups from ranger

  • October 5, 2026 at 8:59 AM
  • 1 reply
  • 5007 views
  • Translate All

delete-scripts.zip

Attached are scripts you can use for ORACLE, PSQL, and MYSQL for deleting users. Directions to how these scripts work are included in the script.

Good practice is to make sure to backup your db before attempting to use and test these scripts.

    1 reply

    Parth_Pathak
    Gold ⭐️
    Parth_Pathak
    Gold ⭐️
    September 20, 2019

    Hello @dvillarreal, 

     

    Thank you for the script files, makes life easy! Just a small edit: 
    The proc.psql file     was missing one SQL statement @line 96:

    delete from x_user_module_perm where user_id = x_portal_user_id;

     

    We were facing the below issue while trying the commands from psql file manually:

     

    ERROR:  update or delete on table "x_portal_user" violates foreign key constraint "x_user_module_perm_fk_userid" on table "x_user_module_perm"
    DETAIL:  Key (id)=(19) is still referenced from table "x_user_module_perm"

     

    Because of the above blocker, the script was not deleting the users from the DB.

     

    Once we added the missing SQL statement and ran the deleteRangerUser.sh we were able to use it with successful results.

    Translate
    Terms & ConditionsAccessibility statement