dosubot[bot] commented on issue #30678: URL: https://github.com/apache/superset/issues/30678#issuecomment-2430108183
<!-- Greeting --> Hello @NavinAsokan! I'm here to assist you with any bugs, questions, and contributions. Let's work together to resolve the issue you're encountering. <!-- Answer --> The issue with the "pgsql" schema not showing up in Superset could be related to the security manager's filtering logic, which determines schema accessibility based on user permissions. Superset's security manager uses the `get_schemas_accessible_by_user` method to filter schemas according to the user's access rights. If the "pgsql" schema is not included in the user's permissions, it will not be displayed <sup>[[1]](https://github.com/apache/superset/blob/master/superset/security/manager.py)</sup>. To resolve this, you should check the following: 1. **User Permissions**: Ensure that the user has the necessary permissions to access the "pgsql" schema. This includes checking both direct schema access permissions and permissions derived from accessible datasources. 2. **Security Manager Configuration**: Verify the configuration of the security manager to ensure that it correctly reflects the permissions for the "pgsql" schema. 3. **Schema Access**: Confirm that the "pgsql" schema is included in the `schema_access` permissions for the user. By addressing these areas, you should be able to determine why the "pgsql" schema is not appearing and make the necessary adjustments to display it. <!-- Dosu Comment Footer --> *To continue talking to [Dosu](https://dosu.dev), mention @dosu.* -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org
