Creating Users in Apache Superset Programmatically

[Harikrishnanvc]

I'm exploring ways to programmatically create users in Apache Superset. As of now, I couldn't find a straightforward way to achieve this through an API endpoint provided by Superset.

My use case requires the ability to automate user creation from our side rather than relying solely on the web interface for user management. I understand that direct manipulation of the database is possible but not recommended due to potential security risks and database integrity concerns.

Could someone provide insights or guidance on how to programmatically create users in Apache Superset in a safe and supported manner? Is there an existing API endpoint or method that I might have overlooked?

[alisharifi2000]

Hi,

I'm having this issue as well. While searching, I found this Stack Overflow link that might be helpful:

https://stackoverflow.com/questions/75442868/creating-a-apache-superset-user-through-api

Based on this link, you should add FAB_ADD_SECURITY_API = True to your superset_config.py file. This will enable new endpoints for getting the user list and creating new users.

However, I'm facing a challenge. I can define a user, but I'm unsure how to set permissions for a new role and create the role itself using the API.

I hope this clarifies the issue better.