Hello, I am having an issue similar to the one described in this unanswered StackOverflow question. <http://stackoverflow.com/questions/27556329/sqlalchemy-reflection-on-dbs-with-limited-permissions> My issue is that I need to load the data from a table where the SELECT permission is denied for a couple columns. I only want to load the data for the columns where I do have SELECT permission. I tried this: table = Table(tableName,metadata, autoload_with=engine, schema=schemaName, include_columns=['allowedColumn1']) but it gave this error: sqlalchemy.exc.ProgrammingError: (mysql.connector.errors.ProgrammingError) 1142 (42000): SHOW command denied to user 'username'@'localhost' for table 'tableName' [SQL: 'SHOW CREATE TABLE `databaseName`.`tableName`'] I think this is because MySQL requires the user to have full SELECT privileges in order to do SHOW CREATE TABLE, but the documentation is not clear about this, vaguely saying "you must have some privilege for the table" <http://dev.mysql.com/doc/refman/5.7/en/show-create-table.html>.
Is there some way for me to work around this? I cannot ask for any privileges for the protected columns, but I may be able to convince the administrator to give me other read privileges if necessary. Ideally though, I would like a way to reflect the allowed columns without having to change any MySQL settings. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
