radhakvnr opened a new issue #15782: URL: https://github.com/apache/superset/issues/15782
A clear and concise description of what the bug is. ab_view_menu and ab_permissions_view tables are getting loaded with numerous amount of rows when a new database connection has been created. ### Expected results FAB should create the permissions based on the database specified or the tables that have been imported ### Actual results FAB is creating the permissions for all the schemas inside a database. #### Screenshots the database connection presto://host:port/database/ has 230 schema's. Once the Database connection has been saved it is automatically adding the 230 rows in ab_view_mneu table and gradually increasing # of rows in ab_permission_view table of metadata. #### How to reproduce the bug 1. Go to 'Create database and enter the database connection where it has multiple schemas' 2. Click on 'Add Database' 3. Scroll down to 'Metadata tables and query the ab_view_menu and ab_permission_view tables ' 4. See error:- you will get the increasing in number of rows than expected. ### Environment (please complete the following information): - superset version: `1.1.0 and 1.2.0` - python version: `3.7` - node.js version: `node -v` ### Checklist Make sure to follow these steps before submitting your issue - thank you! - [ ] I have checked the superset logs for python stacktraces and included it here as text if there are any. - [ x] I have reproduced the issue with at least the latest released version of superset. - [ x] I have checked the issue tracker for the same issue and I haven't found one similar. ### Additional context Add any other context about the problem here. -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
