[sqlalchemy] Read only connection with Table reflection

2007-08-29 Thread Jason Koelker
I am attempting to use SQLAlchemy's table reflection to access a MSSQL 2k database. However the user I can connect with only had db_datareader access. When SQLAlchemy tries to load the schema, it attempts a rollback at the end, which the user does not have permission to execute: 2007-08-29

[sqlalchemy] Re: Read only connection with Table reflection

2007-08-29 Thread Jason Koelker
On Aug 29, 7:27 pm, Michael Bayer [EMAIL PROTECTED] wrote: On Aug 29, 2007, at 1:55 PM, Jason Koelker wrote: I am attempting to use SQLAlchemy's table reflection to access a MSSQL 2k database. However the user I can connect with only had db_datareader access. When SQLAlchemy tries