sqlalchemy-bot

**Michael Bayer ([@zzzeek](https://github.com/zzzeek)) wrote:** well this depends a lot on what kind of database and environment you're working within. I think in the usual case, user2 has permissions to SELECT/INSERT/UPDATE/DELETE...

**leo.wandersleb ([@giszmo](https://github.com/giszmo)) wrote:** Thank you Mike for your answer. ALL TABLES IN SCHEMA only works on those tables EXISTING in the schema and the SO you linked was one of...

**Brian DeRocher wrote:** This would be useful as a full blown feature.

**Changes by Michael Bayer ([@zzzeek](https://github.com/zzzeek)):** * added labels: **low priority**

**Changes by Michael Bayer ([@zzzeek](https://github.com/zzzeek)):** * added labels: **op directives**

**Changes by Michael Bayer ([@zzzeek](https://github.com/zzzeek)):** * changed **title** from "app user can't access alembic user's creation" to "create op framework for grants?"

**Anonymous wrote:** Try this sqlalchemy declarative base: id = db.Column(db.Integer, db.Sequence("s_%s" % __tablename__), primary_key=True) but alembic revision autogeneration make migration scrip without any sequence.

**Michael Bayer ([@zzzeek](https://github.com/zzzeek)) wrote:** autogenerate doesn't look at sequences right now, no. there's a lot of TODOs for autogenerate, mainly schema support. I will reiterate that you don't need autogenerate...

**Anonymous wrote:** Thank you for advice. I will try to use this example. Sure that autogenerate would have done it much faster than I. Hopefully that this enhancement soon will...

**Brian DeRocher ([@openbrian](https://github.com/openbrian)) wrote:** I got this working. Would like feedback on my work. Please let me know how. I just emailed the mailing list with more information/questions.