qleroy commented on issue #29299:
URL: https://github.com/apache/superset/issues/29299#issuecomment-2770397342
> Yeah, also had this problem - it's difficult to make superset refresh the
schema_access permissions after updating the database schema. I have used this
script as part of my provisioning setup:
>
> import superset
> from superset import security_manager as sm
>
> def refresh_db_schemas(dbname):
> from superset.daos.database import DatabaseDAO
>
> # superset does not automatically refresh the schema_access
permissions after DB schema changes,
> # let's do it manually for now (code parts from upstream
superset/superset/databases/api.py)
> database = DatabaseDAO.get_database_by_name(dbname)
> schemas = database.get_all_schema_names(cache=False)
> for schema in schemas:
> sm.add_permission_view_menu("schema_access",
sm.get_schema_perm(database, schema))
>
> app = superset.create_app()
> with app.app_context():
> refresh_db_schemas("mydb")
Since SIP-95, `sm.get_schema_perm` gets a `catalog` parameter as a second
parameter before `schema`, so we should use `sm.get_schema_perm(database_name,
schema_name)`,
the correct snippet to update database schemas programmatically is
```python
import superset
from superset import security_manager as sm
def refresh_db_schemas(dbname):
from superset.daos.database import DatabaseDAO
# superset does not automatically refresh the schema_access permissions
after DB schema changes,
# let's do it manually for now (code parts from upstream
superset/superset/databases/api.py)
database = DatabaseDAO.get_database_by_name(dbname)
schemas = database.get_all_schema_names(cache=False)
for schema in schemas:
sm.add_permission_view_menu("schema_access",
sm.get_schema_perm(database, schema=schema))
app = superset.create_app()
with app.app_context():
refresh_db_schemas("mydb")
```
--
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]
