Administration and User Roles

Superset includes built-in roles that help administrators manage access to data, dashboards, and SQL functionality.

Admin

The Admin role has full access to application configuration, security settings, database connections, dashboards, charts, and user administration.

Alpha

The Alpha role is intended for advanced users who need broad access to data sources and analytical workflows. Alpha users can create and modify content and work with data sources, but they do not manage permissions for other users

Gamma

The Gamma role is intended for users who primarily consume content. Gamma users can view only the data sources, charts, and dashboards that they have been granted access to.

SQL Lab

The sql_lab role enables access to SQL Lab. Database-level access still needs to be granted appropriately for non-admin users.

Public

The Public role is the most restrictive built-in role and is used for anonymous or unauthenticated access scenarios when such access is explicitly configured.

Role Management Guidance

• Upstream Superset guidance recommends treating built-in roles carefully.
• In general, it is better to assign roles and complementary permissions through supported configuration patterns than to rely on ad hoc changes to the default role definitions.
• Built-in roles may be synchronized back to their expected definitions during Superset initialization and upgrade workflows.

Uninstallation

In an Ambari-managed ODP deployment, Superset uninstallation typically involves removing the service from Ambari first and then uninstalling the corresponding mpack from the management node.

Stop and Delete the Service in Ambari

• Begin by stopping the Superset service from the Ambari UI.
• After the service is stopped, use the Ambari service actions to delete or remove the Superset service from the cluster.

Uninstall the MPack

• After the service has been removed from Ambari, uninstall the Superset mpack from the management node.
• Use the following command to uninstall the mpack:

xxxxxxxxxx

ambari-server uninstall-mpack --mpack=uperset-ambari-mpack

• After uninstallation, verify that the Superset service definition is no longer present in Ambari.