After 6 hours of searching and debugging,finally figured out the
permission needed for table reflection, those are:
   "select", and "connect replication"
for ORM to work, you need one more:
   "Alter any schema"
to do add() or delete() you obviously need more permission,
respectively.
Those are specific permissions under MS Sql server 2005.

When doing reflection and orm mapping, did not see any exception
regarding permissions.

Anyway, thank you Michael. You info helps.

-- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to 
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en.

Reply via email to