How do I remove LDAP accounts from Ambari

[#1]

I loaded LDAP accounts into Ambari and now need to remove them and re-sync. How do I remove the accounts?

[#2]

@Scott Shaw

I believe you need to clean it up from ambari database.

for example:

[root@nsfed01 ~]# psql dbname username

Password for user ambari:

psql (8.4.20)

Type "help" for help.

ambari2112=> \dt

ambari2112=> select * from users where ldap_user=1;

user_id | principal_id | ldap_user | user_name | create_time | user_password | active | active_widget_layouts

---------+--------------+-----------+-----------+-------------+---------------+--------+-----------------------

(0 rows)

delete from users where ldap_user=1;

I aambari2112=> select * from users;

[#3]

@Paul Codding Is it ok to follow this approach?

[#4 · Accepted solution]

Scott, you can use the API to remove them:

curl --insecure -u admin:$PASSWORD -H 'X-Requested-By: ambari' -X DELETE http://$AMBARI_HOST:8080/api/v1/users/paul

[#5]

@Paul Codding This is helpful. Thanks! I believe , delete statement is not good idea to run..Comments?

[#6]

We went down the path of deleting directly from Oracle but ran into a bunch of relational constraints.

[#7]

Could you share delete statements for oracle?

@Scott Shaw

[#8]

We ended up going with Paul's solution and didn't try to delete from Oracle. Thanks for all your input and help!

[#9]

I've created an internal JIRA to support bulk deletion from the CLI

[#10]

@Paul Codding Do you have jira number? Is it internal?